I have this data on a table:

Owner,Car1,Car2,Car3,...Car15,Model1,Model2,Model3 ,...Model15

I want to split the table elements to and save it to a new table:

Owner,Car1,Model1
Owner,Car2,Model2
Owner,Car3,Model3
...
Owner,Car15,Model15

How can I achieve this?

            SELECT Owner, Car1 Car, Model1 Model FROM YourTable
UNION ALL SELECT Owner, Car2, Model2 FROM YourTable
UNION ALL SELECT Owner, Car3, Model3 FROM YourTable
UNION ALL SELECT Owner, Car4, Model4 FROM YourTable
UNION ALL SELECT Owner, Car5, Model5 FROM YourTable
UNION ALL SELECT Owner, Car6, Model6 FROM YourTable
UNION ALL SELECT Owner, Car7, Model7 FROM YourTable
UNION ALL SELECT Owner, Car8, Model8 FROM YourTable
UNION ALL SELECT Owner, Car9, Model9 FROM YourTable
UNION ALL SELECT Owner, Car10, Model10 FROM YourTable
UNION ALL SELECT Owner, Car11, Model11 FROM YourTable
UNION ALL SELECT Owner, Car12, Model12 FROM YourTable
UNION ALL SELECT Owner, Car13, Model13 FROM YourTable
UNION ALL SELECT Owner, Car14, Model14 FROM YourTable
UNION ALL SELECT Owner, Car15, Model15 FROM YourTable

If you at the same time want to remove duplicates, omit ALL as

        SELECT Owner, Car1 Car, Model1 Model FROM YourTable
UNION SELECT Owner, Car2, Model2 FROM YourTable
UNION SELECT Owner, Car3, Model3 FROM YourTable
UNION SELECT Owner, Car4, Model4 FROM YourTable
UNION SELECT Owner, Car5, Model5 FROM YourTable
UNION SELECT Owner, Car6, Model6 FROM YourTable
UNION SELECT Owner, Car7, Model7 FROM YourTable
UNION SELECT Owner, Car8, Model8 FROM YourTable
UNION SELECT Owner, Car9, Model9 FROM YourTable
UNION SELECT Owner, Car10, Model10 FROM YourTable
UNION SELECT Owner, Car11, Model11 FROM YourTable
UNION SELECT Owner, Car12, Model12 FROM YourTable
UNION SELECT Owner, Car13, Model13 FROM YourTable
UNION SELECT Owner, Car14, Model14 FROM YourTable
UNION SELECT Owner, Car15, Model15 FROM YourTable

I would suggest changing the table structure. Have an owernes table and a related table of cars that they own.

thank you very much Peso. How can I omit null values?
For example, car1 to car5 have values and car6 to car15 are nulls. How can I omit car6 to car15 and model6 to model 15?

@jbenson001, I would love to change the structure but I can't some third party application is using that type of structure that's is why I'm splitting it.

Something like this?

            SELECT Owner, Car1 Car, Model1 Model FROM YourTable WHERE Car1 IS NOT NULL
UNION ALL SELECT Owner, Car2, Model2 FROM YourTable WHERE Car2 IS NOT NULL
UNION ALL SELECT Owner, Car3, Model3 FROM YourTable WHERE Car3 IS NOT NULL
UNION ALL SELECT Owner, Car4, Model4 FROM YourTable WHERE Car4 IS NOT NULL
UNION ALL SELECT Owner, Car5, Model5 FROM YourTable WHERE Car5 IS NOT NULL
UNION ALL SELECT Owner, Car6, Model6 FROM YourTable WHERE Car6 IS NOT NULL
UNION ALL SELECT Owner, Car7, Model7 FROM YourTable WHERE Car7 IS NOT NULL
UNION ALL SELECT Owner, Car8, Model8 FROM YourTable WHERE Car8 IS NOT NULL
UNION ALL SELECT Owner, Car9, Model9 FROM YourTable WHERE Car9 IS NOT NULL
UNION ALL SELECT Owner, Car10, Model10 FROM YourTable WHERE Car10 IS NOT NULL
UNION ALL SELECT Owner, Car11, Model11 FROM YourTable WHERE Car11 IS NOT NULL
UNION ALL SELECT Owner, Car12, Model12 FROM YourTable WHERE Car12 IS NOT NULL
UNION ALL SELECT Owner, Car13, Model13 FROM YourTable WHERE Car13 IS NOT NULL
UNION ALL SELECT Owner, Car14, Model14 FROM YourTable WHERE Car14 IS NOT NULL
UNION ALL SELECT Owner, Car15, Model15 FROM YourTable WHERE Car15 IS NOT NULL

Or, without duplicates,

            SELECT Owner, Car1 Car, Model1 Model FROM YourTable WHERE Car1 IS NOT NULL
UNION SELECT Owner, Car2, Model2 FROM YourTable WHERE Car2 IS NOT NULL
UNION SELECT Owner, Car3, Model3 FROM YourTable WHERE Car3 IS NOT NULL
UNION SELECT Owner, Car4, Model4 FROM YourTable WHERE Car4 IS NOT NULL
UNION SELECT Owner, Car5, Model5 FROM YourTable WHERE Car5 IS NOT NULL
UNION SELECT Owner, Car6, Model6 FROM YourTable WHERE Car6 IS NOT NULL
UNION SELECT Owner, Car7, Model7 FROM YourTable WHERE Car7 IS NOT NULL
UNION SELECT Owner, Car8, Model8 FROM YourTable WHERE Car8 IS NOT NULL
UNION SELECT Owner, Car9, Model9 FROM YourTable WHERE Car9 IS NOT NULL
UNION SELECT Owner, Car10, Model10 FROM YourTable WHERE Car10 IS NOT NULL
UNION SELECT Owner, Car11, Model11 FROM YourTable WHERE Car11 IS NOT NULL
UNION SELECT Owner, Car12, Model12 FROM YourTable WHERE Car12 IS NOT NULL
UNION SELECT Owner, Car13, Model13 FROM YourTable WHERE Car13 IS NOT NULL
UNION SELECT Owner, Car14, Model14 FROM YourTable WHERE Car14 IS NOT NULL
UNION SELECT Owner, Car15, Model15 FROM YourTable WHERE Car15 IS NOT NULL

Thank you very much peso. What's with the nick anyway? Just curious, its our currency.

It has to do with my name, Peter Larsson. My nick was founded a long time ago...

That's cool.
I used your sql query but it timed-out.
I came up with this:

Select @xOwner=Owner,
       @xCars=Car1+'|'+Car2+'|'+Car3+'|'+Car4+'|'+Car5+'| '+Car6+'|'+Car7+'|'+
       Car8+'|'+Car9+'|'+Car10+'|'+Car11+'|'+Car12+'|'+Ca r13+'|'+Car14+'|'+Car15,
       @xModel=Model1+'|'+Model2+'|'+Model3+'|'+ Model4+'|'+Model5+'|'+ Model6
       +'|'+Model7+'|'+Model8+'|'+ Model9+'|'+Model10+'|'+ Model11+'|'+
       Model12+'|'+ Model13+'|'+Model14+'|'+ Model15
From MyTable

Insert Into NewTable
    Select @xOwner,Value1,Value2
    from dbo.fn_Split(@xCars,@xModel,'|')

where dbo.fn_Split is a function that returns a table.