Discussion Locked

Converting Colums To Rows in Excel

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Currently we have a dump setup from J.D. Edwards OneWorld to excel for data manipulation etc. The problem is it comes in with the column headings along the top, and the subsequent data underneath. My question is what is the easiest way to change it so the headings are along the rows and the data flows left to right instead of top to bottom?

4 replies

by dklippert

Copy the data select a destination and then go to Edit>Paste Special. In the lower right corner you can choose Transpose to swith the data orientation.

by d'arcy

That was exactly what I was looking for, Thanks a bunch, saved me a lot of time!!!

This discussion is closed to new replies.