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!
Solved! Go to 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
Kudos Fernando! It worked perfectly. So much to learn still! Thank you.