Formula to group values based on above cell?

[JumboCactuar]

Hi,
Didn't know how to word the title, I have data in the following format:

00100 | A1A
00101 |

00102 | B6A
00103 | B9H

00302 | A7R
00403
00404

00309 | B8R
00408 | E7S

I need an helper column (C) to fill down the B column values
Example: 00101 = A1A
00403 and 00404 = A7R

There is sometimes spaces between rows

Appreciate any help

 

[gaz_chops]

In C1 enter
=B1

In C2 enter
=IF(A2="","",IF(B2="",C1,B2))

 

[mail2master]

	A	B	C
1
2	100	A1A	A1A
3	101		A1A
4	102	B6A	B6A
5	103	B9H	B9H
6	302	A7R	A7R
7	403		A7R
8	404		A7R
9	309	B8R	B8R
10	408	E7S	E7S

<tbody>
</tbody>

Formula in Cell C2: =IF(B2="",C1,B2)
Drag down to the end..... Hope this suffice your requirement.

 

[gaz_chops]

	A	B	C
1
2	100	A1A	A1A
3	101		A1A
4	102	B6A	B6A
5	103	B9H	B9H
6	302	A7R	A7R
7	403		A7R
8	404		A7R
9	309	B8R	B8R
10	408	E7S	E7S

<tbody>
</tbody>

Formula in Cell C2: =IF(B2="",C1,B2)
Drag down to the end..... Hope this suffice your requirement.

If there are blank rows this won't work.