Bila I Tarik column ke bwh ,dia jadi macam ini
My expectation ,
YELLOW : I want it auto change …016,017,018,019,020 and so on
BLUE : maintain the figure which is C12
So what I do now, I Tarik column ke bawah , then I key in manual tukar satu satu yg kuning ang biru tu
Note: This could be one of the solutions, but I believe the new PowerQuery can do the same, faster.