I have a spreadsheet that appears as follows.
How can I replace the number "1" in the cells with the values in the topmost
cell for the reach corresponding column?? I know find and replace would work,
but it's a large spreadsheet, so was looking for something quicker.

Thanks!!!

12 12 12 4 4 8 8
1
1
1
1
1
1
1
1
1
1

1
1

1

1