How To Insert Blank Rows in Between Data

[crazybeauti_ful]

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*

*blank row*

BBB            11/29      -1.00

BBB             10/29      1.00

*blank row*

*blank row*

CCC            10/29       100.00

*blank row*

*blank row*

DDD             08/30      200.00

Thanks!

[RichardAlt]

Try this! Thanks.

[Jonathan-Sherman · Accepted solution]

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

[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.

Current Output:

Account      Date      Amount            Subtotal

AAA                                                   52,000.00

AAA            11/28      -52,000.00

BBB                                                    -2.00

BBB            11/29      -1.00

BBB             10/29      1.00

CCC                                                   100.00

CCC            10/29       100.00

DDD                                                    200.00

DDD             08/30      200.00

Desired Output:

Account      Date      Amount          

AAA            11/28      -52,000.00

                                    52,000.00

*blank row*

*blank row*

BBB            11/29      -1.00

BBB             10/29      1.00

                                   -2.00

*blank row*

*blank row*

CCC            10/29       100.00

                                     100.00

*blank row*

*blank row*

DDD             08/30      200.00

                                    200.00

Thank you for your help.

[OllieClarke · Accepted solution]

Hi @crazybeauti_ful 

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

[crazybeauti_ful]

It worked! Thanks, Ollie!

[patternfinder]

Jonathan,

This solution worked perfectly for a project I had. Thank you for posting!

Angela