Forum Discussion
Excell formula help
Hi, I would like help to merge multiple rows and columns into one continuous row. Eg - all data to be spread across A1,B1,C1,D1,E1,F1,G1,H1,I1,J1,K1 etc FROM: B4,C4,A6,B6,A7,B7,B8,A9,B9,A11,B11 - Is ...
ttlj2 IF your spreadsheet continues with exactly those same gaps (12 rows between identical items) then you can copy the formulas in the second sheet in this workbook attached.
I've used the INDIRECT function to increase the row references by 12 in each new row. To the right and across the top I've created a "helper column" and a "helper row" to assist in creating the address you are directing the formula to in the INDIRECT function.
It's crucial, though, that you have these new records 12 rows apart.
This is an example of what I am working with and have over 15000 similar lines.