I have some data that is arranged horizontally in rows that repeats the same type of data every 4 rows. It is repeated 12 times per row. I want to arrange the data vertically. So I want to identify the last row in the workbook, currently row 59 (although that will change everytime I add data). Select AW:59-AZ:59 and insert into E:60-H:60. Cut the next set of data: AS:59-AV:59 and insert into E:61-H:61. Etc. repeated until the data has been cut from I:59-L:59 and pasted into E:70-H70. Then I will need to loop the whole thing and do it in row 58, etc until I get to row 1. Row 1 contains headings and not data.