How can I transpose or convert rows of data into columns of data:

When I was using Excel 2000, there was an Excel add-in where I could highlight rows of information and then transpose these into columns of information. Since we have upgraded to Excel 2003, the same Excel add-in does not work and I have not been able to find a simple solution to transpose my information from a horizontal view to a vertical view or the reverse.

Or do I just have to move 53 columns (weeks) of 4 rows one cell at a time to 4 columns of 53 rows (weeks)?

Anyone have any ideas on how to make this happen?

Without knowing how many rows you're talking about that's quite a bit of data, ie a lot of formulae to transpose... you could perhaps use a VBA routine to do this for you ?

Please Login or Register  to view this content.