How can I merge the text of next row and then auto-fill for empty row?

[PhuongTran52]

Hi, 

Thank you for viewing this question

I have a set of data like this, with the name of product is divided into 2 rows, while some rows are empty

I want to merge the name into 1 and then fill the empty rows with the correct name

Can someone help me? Thank you so much

Here a picture for easy understanding

[Emil_Kos · Accepted solution]

Hi @PhuongTran52,

I have created a workflow for you:

I can imagine it is possible to skip one of those multi rows formula but it took me a while to figure it out:

The output:

[PhuongTran52]

It really works! Thank you so much!