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

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???

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

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


On Apr 11, 12:30*pm, Duke Cutshall <Duke
wrote:
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???

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

Try

Paste Special | Transpose


"Duke Cutshall" <Duke wrote in message
...
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???

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

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

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

This should get you started:
http://www.freefilehosting.net/download/3f6j7

I believe the file came from here (I found it a looonnngg time ago):
http://www.wabash.edu/econexcel/


Regards,
Ryan---

--
RyGuy


"Dave" wrote:

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