Hello,
Short and sweet (Excel 2010). I have about 2000 rows of data which are about 12 columns long. I need a macro that will transpose each then stack them in one column. For example.

I have info in row 1 columns A-L.
I have info in row 2 columns A-L.
etc.
etc.

I would like to:
1) Take row 1 A-L and copy it into a new sheet (transposed) so that it is now rows 1-12 column A
2) Take row 2 A-L (from the original source data) and copy it into the same "new" sheet (transposed) so that it is just below the previous info. In rows 13-24 column A...and so fourth

So the end result would be all the source data in a new sheet in column A rows 1-24,000 (2000 X 12....in this example)

I cant write Macros and my boss is the type of person that says "I don't care how you do it...just get it done." So I am at the mercy of this beloved forum.

Thanks for your time and hopefully help.
Drewfiss