Inserting two blank rows based on condition

Question

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 #TypeFundFund Name1234BuyABCDCoffee Fund1234 ABCDTotal1234BuyEFGHSoda Fund1234 EFGHTotal3456ContributionWXYZWhiskey Fund3456RepaymentWXYZWhiskey Fund3456ContributionWXYZWhiskey Fund3456ContributionWXYZWhiskey Fund3456 WXYZTotal

I would like it to look like this:

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

fmvizcaino · Accepted Answer

Hi @andrewplaice ,

You can do that with the generate rows tool.

Example attached as well.

Best,

Fernando Vizcaino