Try

Copy the listSelect a blank cellRight clickPasteSpecialSelect TransposeOK

If this post helps click Yes
---------------
Jacob Skaria


"SwEdIsH_OfFiCe_UsEr" wrote:

I have a vertical list that I want to make horizontal instead. Is there an
easy way to do this other than marking, dragging and dropping each post on a
separate column? How do I reverse the process if I instead have a long row
that I want to make into one column?