[Solved] Transpose Row of Column headers to Column of rows

[pizzipie]

In libreoffice calc I want to transform 1 row of column headings to a single column

ie: First Name Last Name Display Name Nickname Primary Email etc etc etc

To: First Name
Last Name
Display Name
Nickname
Primary Email
etc
etc
etc

[RusselB]

Highlight the row for the columns that have data (including any columns you might have for visual spacing)
Press Ctrl+C NOTE: Use Ctrl+X if you want to move, rather than duplicate the entries
Put the cursor in the top cell of the column where you want the information to be put.
Press Ctrl+Shift+V
In the Paste Special dialog, check Paste All (unless you only want certain properties pasted) and Transpose.
Click OK

[pizzipie]

Thank you Russel, Works very well!

R