Dragging from rows to columns

[kufta4]

I have data going across in a cell. 5 columns worth per line. I would like to have that data going up and down extending from Rows 1 to 5.

Instead of

Adam James Michael Matt David

I want

Adam
James
Michael
Matt
David



Is there a way to do this without manually having to move it all 1 cell at a time?

[guyute76]

First, highlight and copy the cells. Then go to Paste Special, and click the Transpose box in the lower right-hand corner, then click OK.

[kufta4]

You are the man. Thanks a lot. I knew there had to be an easier way.