Multiple Data Header Replication

[Therajest]

Seeking Help!

Been grapling with how to replicate header data in underlying rows until the next header appears and so on. I shall really appreciate pointers on how to solve the challenge.

Attached excel file and screen shot of the input row file and desired output file.

Thanks.

[atcodedog05]

Hi @Therajest 

Here is how you can do it.

Workflow:

Hope this helps : )

[binu_acs]

@Therajest  similar to @atcodedog05 approach