Can I reverse the axes of a populated worksheet (X to Y, Y to X)?

D

Duke Cutshall

I need to reverse the data, by reversing the axes, to facilitate transferring
the data into another spreadsheet(worksheet). The stuff in the columns needs
to be in rows, to match the rest of my worksheets, including the names of the
columns. Any way to flip it???
 
K

krcowen

Duke

If this is a one time deal, you can just copy from the original
format, then use Edit-Paste Special- Transpose to the new location.
If you need something that dynamically links from the original X-Y
arrangement to another spot in the Y-X arrangement, you can do that
using the offset function.

Good luck.

Ken
 
D

Dave

Hi Duke,
Select all your data.
Right click > COPY
Right click > Paste Special
Tick the TRANSPOSE tickbox
OK
Regards - Dave.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing the setting of X,Y axes 0
X,Y,Z values to be extracted and posted respectively in excel 5
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Can you display mathematical equations in Excel? 4
Chart Displays in reverse order 1
Switch x and y axes 3
Find match between cells and copy data 7
Compare cells and copy columns after match 2

Top