Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

flip rows into columns

Status
Not open for further replies.

scottaherbst

Technical User
Jan 18, 2007
46
0
0
US
Hi,

I have data that is in rows that I would like to move into columns. Any fast way to do this?
 
I figured it out.

Highlight the data you want to flip, create a new worksheet, highlight a column, right click for "paste special" check "transpose" and there you are.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top