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