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

Discuss the spreadsheet application

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

Postby pizzipie » Wed Nov 20, 2019 3:15 am

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
Last edited by pizzipie on Wed Nov 20, 2019 8:09 pm, edited 2 times in total.
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am

Re: Transpose Row of Column headers to Column of rows

Postby RusselB » Wed Nov 20, 2019 4:38 am

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
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5661
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Transpose Row of Column headers to Column of rows

Postby pizzipie » Wed Nov 20, 2019 8:07 pm

Thank you Russel, Works very well!

R
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am


Return to Calc

Who is online

Users browsing this forum: npandit and 39 guests