Discussion Locked

Orientation of the Data in Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

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

This discussion is closed to new replies.