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!

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

Inverting Rows&Columns in Excel

Status
Not open for further replies.
tmryan

tmryan

Programmer
Dec 22, 2000
73
US
Is there a way to invert rows and columns in Excel?
In other words - I want my rows to become columns and my columns to become rows.

Thanks
Tim Ryan
 
Sort by date Sort by votes
Yup, been there. The answer is simple - Select the complete range which you want to change and Edit,Copy it.

Next, Go to another area (like another sheet) and choose the upper-left cell which you would like the data to reside.

Choose Edit, Paste Special and click the 'Transpose' box.

Simple, now that you know the trick.

Tim
 
Upvote 0 Downvote
Tried everything but the simple approach.

Thanks
Tim Ryan
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
485
combo
combo
EFFEY
  • Locked
  • Question
I have three columns in excel named 1
Replies
5
Views
203
EFFEY
EFFEY
Andrzejek
  • Locked
  • Question
Compare multiple columns in Excel 1
Replies
4
Views
999
combo
combo
Scott24x7
  • Locked
  • Question
Help when printing rows and objects in Excel
Replies
4
Views
128
combo
combo
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
295
Bijugate
Bijugate

Part and Inventory Search

Sponsor

Back
Top