Exchange rows and columds in Excel

[pigworm]

Hi!
What I want to do is to replace columns with rows and vice versus, for example, transform a 3x5 table into a 5x3 table. Does anyone know how to do it?

 

[BMeek]

When there is something I want to accomplish via code and I know how to do it manually, I record my steps as a macro. Then I have the code to review and tweak to make sure it fits all my future needs. I suggest going into an Excel file with a 3X5 table. Turn on your macro recording, then copy and "paste special" clicking the transpose option to a new area. Then review your code to see if it will fit your needs or what you need to adjust.

For example, if you want to have the process handled by the click of a button, move the code for the macro into the click event of the button. If you are looking for a quick fix or the place to get started, this process sometimes helps.


Bryan Meek
bmeek@pacbell.net

http://www.handtech.com/meekent

A TC in your corner gives you the personal attention you need to find the right technology solutions for your business.