Convert Multiple Columns to Rows including blank cells

I currently have a spreadsheet that I had someone help me to convert from multiple rows to columns:

http://www.excelforum.com/excel-prog...-new-post.html

Now I need a script to change the data so that each column is now in row format, (see attached spreadsheet).

Thanks in advance for your help.