Have this:
A1=val
A2=val
A3=val
A4=val
A5=val
A6=val
A7=val
A8=val
Need to turn next column into this:
B1=A1
B2=A1
B3=A2
B4=A2
B5=A3
B6=A3
Excel won't pick up on the pattern, any tips?
Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or into a new row idc.



A1=val
A2=val
A3=val
A4=val
A5=val
A6=val
A7=val
A8=val
Need to turn next column into this:
B1=A1
B2=A1
B3=A2
B4=A2
B5=A3
B6=A3
Excel won't pick up on the pattern, any tips?
Basically need to turn "X" number of cells into twice as many cells, duplicating each cell below itself or into a new row idc.



