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

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:

 

2020-05-20 2.yxmd