create 2 columns from 1

[mnigogos]

As part of a web page development I have been driven nearly mad trying to create this query and have failed. I have created a simplified list to get at the heart of my question:
Given this list:

Person-----Owns
1-------------Toyota
1-------------Ford
1-------------Kia
2-------------Kia
2-------------GM
2-------------Mercedes
2-------------Volvo


Create a query such that it displays as follows:

Person1---------Person2
Kia----------------Kia
Toyota----------GM
Ford-------------Mercedes
--------------------Volvo

Few points:
I suspect I can do it in PHP but was trying to create a simple(!) single step solution in mysql.
I want to avoid having 7 rows, 3 of which have nulls in one column and 4 of which have nulls in the other column.
The way they are listed here creates 5 rows-it simply puts a null in the person1 field since there is an extra value in Person2
The ORDER in which they display is not important nor whether they match up in any way.
My suspicion is that a Union query is required of joins on the person field but this may be my newbie status showing through.
I hope I am posting this in the correct forum.
Thank you!

[Stang02GT]

Maybe try a Union Query

[amitpatel66]

 
SELECT MAX(CASE WHEN id = 1 THEN name else null END) AS ID_1, MAX(CASE WHEN id = 2 THEN name ELSE NULL END) AS ID_2 FROM
(SELECT id,name, row_number() OVER(PARTITION BY ID ORDER BY ID)rn FROM
(SELECT 1 AS ID, 'Toyota' AS NAME FROM DUAL
UNION
SELECT 1,'Ford' FROM DUAL
UNION
SELECT 1, 'Kia' FROM DUAL
UNION
SELECT 2, 'Kia' FROM DUAL
UNION
SELECT 2, 'GM' FROM DUAL
UNION
SELECT 2, 'Mercedes' FROM DUAL))
GROUP BY rn
 
 

I dont have the table structure and data so I had to use the multiple select statements for the data. You can substitute your table name in the query and try executing it.