To take the cells in the row and put them in rows

[adardesign]

simply to take the cells in the row and put them in rows

 

[David Biddulph]

Copy.
Edit/ Paste Special/ Transpose.