We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
rows to columns in excel
baby-mechanic
Posts: 492 Forumite
in Techie Stuff
Hi folks
I've created table in excel, and need to change the information round so that the current rows become columns, and the columns become rows.
(effectively rotating it through 90 degres, if that makes sense !)
Have tried the pivot function to no avail
Any suggestions, apart from rewriting the whole table ?
I've created table in excel, and need to change the information round so that the current rows become columns, and the columns become rows.
(effectively rotating it through 90 degres, if that makes sense !)
Have tried the pivot function to no avail
Any suggestions, apart from rewriting the whole table ?
Baby-Mechanic
The only reason I keep smiling is so that people wonder what I've been up to !!
The only reason I keep smiling is so that people wonder what I've been up to !!
0
Comments
-
-
Hi there,
if you highlight the rows and then choose copy. Once they are selected right click where you want them to appear and choose "paste special" then from the menu click "transpose" and away you go.0 -
Thanks for that.
Always wondered if I'd ever use 'Paste special' !!Baby-Mechanic
The only reason I keep smiling is so that people wonder what I've been up to !!0 -
Once you have used it once you will never stop!0
-
I agree. Paste Link is useful too.
Transpose is so underused.
Some useful Excel tutorials at http://!!!!!!!/bUV4VQHi, we’ve had to remove your signature. If you’re not sure why please read the forum rules or email the forum team if you’re still unsure - MSE ForumTeam0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.6K Banking & Borrowing
- 254.2K Reduce Debt & Boost Income
- 455.1K Spending & Discounts
- 246.6K Work, Benefits & Business
- 603K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.7K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards