Page 1 of 1

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

PostPosted: Wed Nov 20, 2019 3:15 am
by 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

Re: Transpose Row of Column headers to Column of rows

PostPosted: Wed Nov 20, 2019 4:38 am
by 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

Re: Transpose Row of Column headers to Column of rows

PostPosted: Wed Nov 20, 2019 8:07 pm
by pizzipie
Thank you Russel, Works very well!

R