Attached are 2 comma delimited results files (Sample) (First file are Rows 1 to 110 and the Second file are rows 111 to 206) in of a group of 59k comma delimited results files. In column A are 3 letters (H,R and S) to identify each row of data. The first is H which has in the row 2 fields that I need to assign/paste to each row in the S Rows. I do not need to do anything to the R rows. I need to assign/past data from C1(SAR) to Rows L12 to L110 and also assign/paste data from D1(20100901) to Rows M12 to M110.
The next file starts on Row 111 and would need to assign/paste Data in Cell C111(SUF) to rows L121 to L206 and assign/past Data(20100901) in D111 to Rows M121 to M206.
I need the above query/vba code to do this to all 59k results.
The result I am wanting would look like Sample 2.
H Row is always 1 row
R rows can be anywhere from 5 to 14 rows
S rows vary and could be anywhere from 45 rows to 170 rows.