Flash Fill (or some other option)?

Hello.

Please see the two tables below. Data in its current state and what I am trying to achieve.

Essentially, I have a very large data set where I'd like "Name" to be copied down to each of the corresponding "record categories" as shown. The challenge is twofold - i.e., the data set is very large (as stated) and the number of "record category" items can vary from one name to the next.

Is there any way to automate this? I played with Flash Fill but don't think it's the right tool.

THANK YOU to anyone that might know how to fix this.

flash.jpg

If this is a "one-off" rearrangement then one way is:
in a new column on the same row as the first "Bill":
=IF(A2="", C1, A2)
And copy down.
Now you can replace the name column with the newly created column (copy / paste values)
See attached workbook.

If this is something you need to do regularly then some other approach will be needed.

This worked fantastically. Very clever. Thank you so much!

Thanks dflak. Both of these solutions are working for me. And thanks for the tip re posting the workbook. Will do going forward. Thanks to you both.