Orientation of the Data in Excel
Can we change the orientation of data in Excel? E.g If the data is in coloum can it change to row without cutting and pasting individual cell contents.
Jan Feb Mar Apr ->
Jan
Feb
Mar
Apr
Software
Can we change the orientation of data in Excel? E.g If the data is in coloum can it change to row without cutting and pasting individual cell contents.
Jan Feb Mar Apr ->
Jan
Feb
Mar
Apr
by softcorp.us
Hello...
Yes. Use "Paste Special" and check the "Transpose" option.
Steps:
1. Select the cells in the column.
2. File->Copy
3. Select the cells in the row.
4. File->Paste Special
5. Check Transpose.
6. Click OK.
-----Steve Jackson
CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use
by kam.bashir
Thanks for the solution. It will save me lot of time and effort in doing this manually.
by kam.bashir
This discussion is closed to new replies.
Sort by Trending