How do I edit a Microsoft Excel Document to kinda flip everything 90 degrees?
I basically want to make all the data from the columns go in to the rows and the rows go into the columns. Is there a way to flip the axes?
I got a lot of data and don’t want to cut and paste it all by hand. Please save me from this nightmare!
ANSWER PERSON RESPONDS: The feature is called “transpose.” Highlight only the section you want to transpose. Copy (not cut) it (CTRL-C). Put the cursor somewhere blank (you have to paste the transposed table into blank cells, not over the ones you’re copying — you might want to use a new blank sheet). Place cursor in what will be the top left cell. Use Edit…Paste Special (or right-click and choose Paste Special). Click the transpose option at the bottom then click OK.