Insert Blank Rows Based on a Condition

[wht822]

Hi all,

I'm trying to insert a blank row underneath whenever the word 'TOTAL' appears in my Product Type field. Does anyone know of a way to do this? In my example, I would just want a blank row to be inserted where row 11 is and for all the existing data to get moved down. I will need to do this whenever 'TOTAL' appears, which will be another dozen more times in this dataset.

[Aaron_Harter · Accepted solution]

Hi @wht822,

In the attached solution, I've assigned a RecordID, then used a filter to split off any totals, update the RecordID for these new blank rows to show up just below the totals in the data set, then Union the data back together and Sort into the desired order:

 

[Bennel_Wilson]

Hi @wht822 ,

I tried drawing up a workflow for your query. Let me know if this helps.

Input:

Workflow:

Output:

Attached workflow for your reference.

Regards

Benn.

P.S: In case this solves your query, kindly mark this as a solution.