Inserting two blank rows based on condition

[andrewplaice]

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

[fmvizcaino · Accepted solution]

Hi @andrewplaice ,

You can do that with the generate rows tool.

Example attached as well.

Best,

Fernando Vizcaino

[andrewplaice]

It's a thing of beauty!  Thanks for the quick response - it works perfect.  Another aha moment for me.  I appreciate it!