Rotate spreadsheet
I have always wondered how to do this!
Select the data your wish to transpose, then do a PASTE SPECIAL > TRANSPOSE
I have a spreadsheet with column and row headings which I wish to swap while maintaining data inegrity and their doesn't seem to be an auto option for this process.
ie. I want to swap x and y and move the data accordingly.
___Y1 Y2 Y3 Y4
X1 AA AB AC AD
X2 BA BB BC BD
X3 CA CB CC CD
X4 DA DB DC DD
No comments:
Post a Comment