Student’s Excel Question & Answer

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.