Hello,

I have an enormous amount of data that I need to consolidate into a master sheet in excel for statistical analysis. In the following example I need to transfer A1:X1 in this sheet to I5:I28 in the master sheet, A2:X2 in this sheet to I29:I52 in the master sheet, A3:X3 in this sheet to I53:I76 in the master sheet etc.

So the final result would lay out data for this single sheet into one row on the master sheet. Thank you in advance for any help.

Regards
Joe

excel example.jpg