Adding an Empty Row Between Data

Question

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.

Add Empty Row Example.xlsx

atcodedog05 · Accepted Answer

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 : )