Transpose iteratively???

Hello all,

I'm having an issue in which I don't know how to create a macro (as I'm assuming that's what it would take) to essentially iteratively transpose my data. I have a large collection of data, essentially 10 columns...however the rows are replicates of 3, but I want the replicates to be in the columns and not in the rows. I'm hoping it's an easy fix, that I just can't see but any help would be greatly appreciated. I've attached a small sampling of data in which I've converted just 2 rows of the second sheet to what I'm trying to accomplish. Thank you so much in advance for any input!

Best,

Ryan

Transpose Help.xls

Try this...

Please Login or Register  to view this content.

You sir are a gentleman and a scholar!

I can't thank you enough for the quick reply, the code worked absolutely flawlessly!

Best Regards,

Ryan