How to exchange rows and columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,
Does anyone know how to exchange rows for columns and vice versa without
creating a pivot table? ex:
Red Green Blue
Jim 1 2 3
Joe 4 5 6

Changed to

Jim Joe
Red 1 4
Green 2 5
Blue 3 6

THANKS!
Scott
 
Hi

select your data and copy it
click where you want the reversed list (must be outside the selected range)
and choose edit / paste special - transpose
the original data can then be deleted if you wish.

Cheers
julieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
IF AND OR STATEMENT 3
Count with multiple column criteria 2
lookup H&V...or match...index??? 6
Text to rows 4
mr t.valko ..help 8
Return multiple values in one cell doing a single value lookup 4
Popups to look up on two variable columns 1

Back
Top