Transpose a set of 6 rows to one column and repeat for next columns

Hello All,

I'm a newbie to this forum, and I am in need of serious help because me=excel idiot.

I have a rather large set of data. Basically I have data in 42 rows by 89 columns.

I need to transpose the data in one single column, taking every six cells in the column and making one row out of it, the next six cells in the column and making a row below that one, and so on and so forth. Then I need to take the data in the next column and repeat.

Half of my problem has been answered in another thread, http://www.excelforum.com/excel-prog...n-one-row.html.

Unfortunately I need to get this process to carry over to the next 89 columns.

I have a sample data set attached. I'd like the output to be on a separate sheet so I can copy and paste it to a template I have ready. If anyone can come up with a macro for this, I would greatly appreciate it.

Thanks!