How to divide data column wise

[kalpesh.chavda]

Hello,
I want to divide data column wise.
How to displya them.
Like

my query is "select name from user where user_n_id = 22"
I get

  Name
1 ABC
2 CDF

I want to display like this :

Name1   Name2
ABC         CDF

[kchavda]

I have same questions, Need urgently.

[plambert_1]

Has your query just one field?

What is your Database? Some of them have some PIVOT features.

 

[kalpesh.chavda]

I am using mysql.