How To Insert Blank Rows in Between Data

Hi,

I need to insert 2 blank rows after every account in my report. I could not find any online solution that can solve my issue.

Help please!

Current Output:

Account Date Amount

AAA 11/28 -52,000.00

BBB 11/29 -1.00

BBB 10/29 1.00

CCC 10/29 100.00

DDD 08/30 200.00

Desired Output:

Account Date Amount

AAA 11/28 -52,000.00

*blank row*

BBB 11/29 -1.00

BBB 10/29 1.00

*blank row*

CCC 10/29 100.00

*blank row*

DDD 08/30 200.00

Thanks!

Developer Tools

Accepted answers

Jonathan-Sherman

Hi @crazybeauti_ful,

I've taken @RichardAlt solution one step further in order to make it fully dynamic, now it will create the correct number of blank rows no matter how many input rows you have, and will take into account where you have two account numbers the same on subsequent rows the same as "BBB" in your example.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191128 - CreatingBlankRows.yxmd

OllieClarke

Hi @crazybeauti_ful

This workflow will put each account's subtotal in the amount column after the data

subtotal.yxmd

All comments

Try this! Thanks.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

20191128 - CreatingBlankRows.yxmd

RichardAlt

Nice!

crazybeauti_ful

It worked!! 🙂

Can you please also help in transposing the subtotal in this scenario? I had to make another column for subtotal because the formula isn't a straightforward addition so Summary by Grouping wouldn't work but then I had to transpose it so the end result is like in a financial report.