Generate Blank Rows After Each Grouping

[knnwndlm]

Hi SME,

I would like to use the Generate tool to create a blank row after each group of data from different class so that I can see a separator between the classes with the output.  For example, I have the following dataset:

Year   Class    Amount

2022      A        100.30

2023      A          50.33

2022      B         212.00

2021      C         332.22

What I get to see is as follows:

Year   Class    Amount

2022      A        100.30

2023      A          50.33

2022      B         212.00

2021      C         332.22

I could do this the long way using the Transpose/Cross Tab tools. However, I want to understand how to use the Generate Tool to do this.

Thanks,

kwl

[abacon]

@knnwndlm This isn't as intuitive as I am sure you would like it to be but here is a workflow that would do it for the data you provided.

Basically I am adding a 2nd row for each one, if the row is the last one, removing, then removing everything from those rows.

Bacon

[CoG · Accepted solution]

Here are another 2 approaches, one is clearer, leveraging the Union tool to insert blank rows as needed. The other rearranges @abacon's solution to help simplify the tool usage, but requires more complex logic:

Hope this helps and Happy Solving!

[knnwndlm]

@CoG - How do I modify the Generate Row tool above to also insert a blank row at the bottom?  I did this the long way and it worked fine.  Just wondering if it's possible to do all that in the Generate Row tool above in one swoop.  Thank you!

[CoG]

By modifying the Multi-Row Formula Tool:

I added a Record ID Tool as well with Sort Tool to preserve ordering with AMP.