I have this sheet with all the values in one column. Each record is six rows
of column A. Then comes a blank row. Then six more rows for the next record.
Then a blank row. Etc, Etc. for 2218 rows of column A (which is why I need a
macro).

What I want to do is copy each record (all six rows in column A for each
record) and transpose it on the next available row of the following sheet. I
have no clue how to do this. Can someone clue me?

Thanks