Value from 1 cel to another

[Bakar]

Hi everyone
I want to have these datas COPY in column B as follow
Example
COLUMN A COLUMN B
CELL A1=A CELL B1=A
CELL A2=BLANK CELL B1=B
CELL A3=B CELL B1=C
CELL A4=C CELL B1=D
CELL A5=BLANK CELL B1=E
CELL A6=D CELL B1=F
CELL A7=E CELL B1=BLANK
CELL A8=BLANK CELL B1=BLANK
CELL A9=BLANK CELL B1=BLANK
CELL A10=BLANK CELL B1=BLANK
CELL A11=F CELL B1=BLANK
I have used if and vested formula but I can move only 8 cells can I have a macros to do this or any other way I don’t need blank cells in column all blank cells must me down

Bakar

[Bakar]

Hi everyone
I want to have these datas COPY in column B as follow
Example
COLUMN A COLUMN B
CELL A1=A CELL B1=A
CELL A2=BLANK CELL B1=B
CELL A3=B CELL B1=C
CELL A4=C CELL B1=D
CELL A5=BLANK CELL B1=E
CELL A6=D CELL B1=F
CELL A7=E CELL B1=BLANK
CELL A8=BLANK CELL B1=BLANK
CELL A9=BLANK CELL B1=BLANK
CELL A10=BLANK CELL B1=BLANK
CELL A11=F CELL B1=BLANK
I have used if and vested formula but I can move only 8 cells can I have a macros to do this or any other way I don’t need blank cells in column all blank cells must me down

Bakar

Already solved thanks to all members