Macro to transpose rows to columns

[bradyj7]

Hi there,

Would anyone have a macro handy to transpose rows to columns in a worksheet? The number of columns are fixed (A-N) but the number of rows varies from sheet to sheet.

Thank you

John

 

[Joe4]

No need for macro. There is a Special Copy, Paste function that will do this.

Copy -> Paste Special -> Transpose

 

[bradyj7]

Hi,

I'm looking for one to called if a larger macro. I'm looping through 1000s of files in folders and processing them. At the end of the process, they are not in the correct format for the next application so I just need to transpose the rows to columns. The paste special function would take a long time.

John

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=571333

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).