Adding an Empty Row Between Data

[Cfdiaz2103]

Hi Everyone!

I'd appreciate your help if you could help me to figure out how I could add an empty row between 2 rows of data

What I need is adding a empty row between the value "Total" (Field: Cliente) and the next value from the same column, as you can see in the attached file.

Thanks for your support.

[atcodedog05 · Accepted solution]

Hi @Cfdiaz2103 

Here is how you can do it.

Workflow:

1. Using multirow-formula tool to check whether the Cliente is total and its not the last row if yes flag as 1.

2. For every flag 1 generate an extra using gen row tool.

3. For every generated row change the Cliente & value column to blanks.

Hope this helps : )

[Cfdiaz2103]

Hi @atcodedog05 !

I thought it would be more complex.

Thank you 🙂