How to iterrate 1 column in excel

Hey everyone,

I have and Excel doc. I want to iterrate the columns, by that i mean:

A / B / C / D (columns)
4 – 3 – 2 – 10
6 – 3-- 3 – 11
2-- 3 – 2-- 21
4 – 8 – 9 --1

I want to iterate after B so

A / B / C / D//E (columns)
4 – ---- 3 – 2 – 10
6 ------ 3-- 3 – 11
2-- ---- 3 – 2-- 21
4 ------ 8 – 9 --1

so B column will be empty . How can I do it any guesses?

Do you just want to iterate column B? Or all the other four columns except column B?

I want to iterate to right by 1 column starting from B so B will be empty .

B will be C, C will be D etc.
so in the end B will be empty

Simply insert a new column and use set Ordinal (position/sequence) to whichever number you want.

1 Like