I have a preformatted spreadsheet report with cells formatted like below:
A B C D Week1 Week2 CUSTOMER A PRODUCT A MEASURE A MEASURE B MEASURE C CUSTOMER B PRODUCT B MEASURE A MEASURE B MEASURE C
Report can contain thousands of rows. I need to unmerge cells in column A and B, which results in 3 cell blocks, with string contained in the first row of the block. A2 in this case.
I need to autofill the cells in Columns A and B to achieve the following situation:
CUSTOMER A PRODUCT A MEASURE A CUSTOMER A PRODUCT A MEASURE B CUSTOMER A PRODUCT A MEASURE C CUSTOMER B PRODUCT B MEASURE A CUSTOMER B PRODUCT B MEASURE B CUSTOMER B PRODUCT B MEASURE C
Values should be autofilled 2 rows or until cell that contains a value not equal to autofilled value. Then that value should be autofilled until next 2 rows, switched to the value contained in the third cell et cetera.
It should continue to do so until last row-1 containing values (last row contains date and time).
I would like to do this by a VBA loop. Columns A, B and C are always strings and values from Column D onwards are numbers.