Exchange rows and columds in Excel Exchange rows and columds in Excel pigworm (TechnicalUser) (OP) 6 Nov 00 15:55 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? RE: Exchange rows and columds in Excel BMeek (Programmer) 6 Nov 00 16:59 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 Meekbmeek@pacbell.nethttp://www.handtech.com/meekentA TC in your corner gives you the personal attention you need to find the right technology solutions for your business.