Need help to fix data

[gulnozka1986]

I have a data which has multiple headers in a file.  I need to bring in customer name for each specific row.  Can someone help?

Please see attached for raw data and expected data format

[ncrlelia · Accepted solution]

Hi @gulnozka1986,

Please find attached my suggested solution.

Hope it helps.

Cheers, 

Lelia

[gulnozka1986]

Thank you!  It was just what I needed