Duplicating header row throughout output

[andrewplaice]

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 #	Type	Fund	Fund Name
1234	Buy	ABCD	Coffee Fund
1234		ABCD	Total
1234	Buy	EFGH	Soda Fund
1234		EFGH	Total
3456	Contribution	WXYZ	Whiskey Fund
3456	Repayment	WXYZ	Whiskey Fund
3456	Contribution	WXYZ	Whiskey Fund
3456		WXYZ	Total

I would like it to look like this:

Plan #	Type	Fund	Fund Name
1234	Buy	ABCD	Coffee Fund
1234		ABCD	Total
Plan #	Type	Fund	Fund Name
1234	Buy	EFGH	Soda Fund
1234		EFGH	Total
Plan #	Type	Fund	Fund Name
3456	Contribution	WXYZ	Whiskey Fund
3456	Repayment	WXYZ	Whiskey Fund
3456	Contribution	WXYZ	Whiskey Fund
3456		WXYZ	Total

Can someone help me with this?  Thanks!

[fmvizcaino · Accepted solution]

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

[andrewplaice]

Kudos Fernando!  It worked perfectly.  So much to learn still!  Thank you.