Need to change spreadsheet layout

[VoiceInTheWorld]

Hi! I'm new here and need some help. I received a CSV file with 2500 entries, but instead of being in 1 column, from 1 - 2500, they are spread across the top of the spreadsheet (1 in each header column). How do I make them go down instead of across??

[kevin316]

Easy to do

First, select the data, Row 1 in your case, that you want to transpose and copy it to the Clipboard using [Ctrl]+C.

Select the top-left cell of the range you want to copy the transposed data to (A1 for instance).

Click the Home tab (if necessary).

Click the Paste dropdown in the Clipboard group.

Click Transpose (the last icon on the second row).

That's it

[VoiceInTheWorld]

THANK YOU!! It worked perfectly!!