Paste value in merged cells to corresponding cells

[ceytl]

I have merged cells in column A, and would like to paste the values in each corresponding cell in column B.

Example Cell A1:A5 has value of 402, and I want to paste that same value in cells B1, B2, B3, B4, and B5.

Is there a formula for this, or a VBA script?

Thanks

Book1
	A	B	C
1	402	402
2		402
3		402
4		402
5		402
6	3905
7
8
9
10	3080
11
12
13
14
15
16
17
18
19
20
21
22
23	3023
24
25
26
27
28
29
30	1109
31
32
33	1117
34
35
36
37
38
39
40
41
42
43
Sheet1

 

[ceytl]

I figured it out:

=IF(A2<>"",A2,B1)