Good afternoon,
I am assigning data to readers. The primary rows of data are on the first sheet in the workbook, one row per data point. On the second sheet, there are two rows of data related to each row on the first sheet. I would like to number each of the rows on the second sheet the same sequential number as its respective row on the first sheet. Therefore, on sheet 1, the rows are numbered sequentially going up by one increment on each row (e.g., 1, 2, 3, 4, etc.) and on the second sheet, two rows need to have the same number, follwed by the next two rows again with the next sequential number (e.g., 1, 1, 2, 2, 3, 3, 4, 4, etc.). I have tried to use Flash Fill but haven't been able to get it to recognize the pattern.
Any suggestions greatly appreciated.
Best,
Rob
I am assigning data to readers. The primary rows of data are on the first sheet in the workbook, one row per data point. On the second sheet, there are two rows of data related to each row on the first sheet. I would like to number each of the rows on the second sheet the same sequential number as its respective row on the first sheet. Therefore, on sheet 1, the rows are numbered sequentially going up by one increment on each row (e.g., 1, 2, 3, 4, etc.) and on the second sheet, two rows need to have the same number, follwed by the next two rows again with the next sequential number (e.g., 1, 1, 2, 2, 3, 3, 4, 4, etc.). I have tried to use Flash Fill but haven't been able to get it to recognize the pattern.
Any suggestions greatly appreciated.
Best,
Rob