How to create a column basis certain row data

[santhoshrama]

Attaching the excel where I have a list of product codes along with the store names in one column. At the end of group of product codes, the store name is present. I want to create a column taking the store name from the product code column. Can you please let me know if there is a way? Attaching the sample

[JosephSerpis · Accepted solution]

Hi @santhoshrama I mocked up a workflow let me know what you think?

[santhoshrama]

Thanks @JoseohSerpis. This helps!