Duplicating header row throughout output

Question

I posted a question earlier that was solved but is no showing in my alerts for some reason.  In the first question I asked how to add two dynamic null rows.  Of course since then I have been trying to figure out how to duplicate my header row in one of those rows.

My data looks like this:

Plan #TypeFundFund Name1234BuyABCDCoffee Fund1234 ABCDTotal        1234BuyEFGHSoda Fund1234 EFGHTotal        3456ContributionWXYZWhiskey Fund3456RepaymentWXYZWhiskey Fund3456ContributionWXYZWhiskey Fund3456 WXYZTotal

I would like it to look like this:

Plan #TypeFundFund Name1234BuyABCDCoffee Fund1234 ABCDTotal    Plan #TypeFundFund Name1234BuyEFGHSoda Fund1234 EFGHTotal    Plan #TypeFundFund Name3456ContributionWXYZWhiskey Fund3456RepaymentWXYZWhiskey Fund3456ContributionWXYZWhiskey Fund3456 WXYZTotal

Can someone help me with this?  Thanks!

fmvizcaino · Accepted Answer

Hi @andrewplaice ,

I'm inserting my example inside the workflow developed for the other topic.

I'm highlighting the tools added to accomplish this example.

1. Select = change all columns to string format to be able to insert a middle header

2. Multi-row = inserted to eliminated the last two null lines what formula wasn't able to do.

3. Multi-field = one additional condition to insert header name in the middle.

Best,

Fernando Vizcaino