I would like to know if there is a formula that would copy the value of the
data below it.
Sample: (I would like a formula to be created in column B and the result
will be the example below)

Column A Column B
1234 1234
----- 1234
----- 1234
3456 3456
----- 3456
9876 9876
---- 9876
---- 9876
---- 9876
123456 123456
---- 123456

Thank you in advance!