I need to update a set of rows in an Excel worksheet. Here is the example:

*********************
ColA ColB
265004357
Wife
Daughter
Son
Son

265089764
Child
Child
Husband

265098308
Spouse
Daughter
Daughter
*******************

I need to insert the unique number at the beginning of a group of rows (each
unique group is separted by a blank row) into colB and skip to the new uique
number when the group changes. Here is what the data should look like:

*********************
ColA ColB
265004357 265004357
Wife 265004357
Daughter 265004357
Son 265004357
Son 265004357

265089764 265089764
Child 265089764
Child 265089764
Husband 265089764

265098308 265098308
Spouse 265098308
Daughter 265098308
Daughter 265098308
*******************

Can I do this with an Excel formula or do I need to use something else (eg.
VB)?

Please let me know.

Thanks in advance,

Attila