Could someone explain the easiest way to do this.. I can't seem to find the answer..

I have almost 800 rows on a sheet

The data is in Columns A through B


A B
1 X Y
2 A B

What I need to read Col A and B horizontal not vertical

A B C
1 x
2 Y