Hi,
Thanks in advance - this community consistently keeps me progressing with my workflows and it gets easier every day! Here is today's challenge: I need to dynamically add two blank rows after each row where [Fund Name] = "Total".
My data currently 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 | 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 | |
1234 | Buy | EFGH | Soda Fund |
1234 | EFGH | Total | |
3456 | Contribution | WXYZ | Whiskey Fund |
3456 | Repayment | WXYZ | Whiskey Fund |
3456 | Contribution | WXYZ | Whiskey Fund |
3456 | Contribution | WXYZ | Whiskey Fund |
3456 | WXYZ | Total |
Solved! Go to Solution.
Hi @andrewplaice ,
You can do that with the generate rows tool.
Example attached as well.
Best,
Fernando Vizcaino
It's a thing of beauty! Thanks for the quick response - it works perfect. Another aha moment for me. I appreciate it!