How to align data in different colums

[Dhanks13]

Hi Guys,

Please help me how to align data in different columns. Please see below raw data given.

C-1 C-2 C-3
A 1

B JOHN

C CRUZ

-Given the sample above. Can you please help me what would be the formula on this? Because, i'm having a hard time to cut and cut and paste in above the data where it belong.

Thanks a lot in advance for the help. Beginner here

 

[Gerald Higgins]

Hi, it's not clear what you want, or how your data is laid out.
It looks like all your data is currently in column 1, is that right ?

 

[Dhanks13]

Hi there,

I'm really sorry for that. I don't know how to paste screenshot here. Anyway, "1" is in R1-C1 while "John" is in R2-C2 lastly "Cruz" is in R3-C3. How can i align it in one raw and in different columns. Sorry to confuse you sir.

Thank for your immediate response sir

<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>

 

[Gerald Higgins]

OK, I understand how your data is laid out now.

I don't understand how you WANT it to be laid out.

Do you want something like this . . .
...............C1.............C2..............C3
R1...........1...............JOHN...........CRUZ

If that's what you want, I get that, but I'm guessing you have more than just John Croz to deal with, so what does your data look like for 3 or 4 records ?