Insert Blank Row When Data Changes

[Cassie_Shaw]

Hi All,

I have spent the whole morning trying to figure out how to insert a blank row when my data changes in specific column. For example:

Bob

Bob

Bob

Dawn

Dawn

Eric

I would like a blank row after the 3rd Bob, 2nd Dawn and 1 Eric. I have attempted to set up an "ID" (either 0 or 1) to use down the workflow with a Generate Row tool however I am not getting the desired output.

All help is appreciated :)

[binuacs · Accepted solution]

@Cassie_Shaw One way of doing this

[RSreeSurya]

Hi,

Attaching the workflow, have a look.

Please note that in the concatenate end I have given ', '. 

[Cassie_Shaw]

@binuacs @RSreeSurya Thank you both for your quick help. The issue was with my multi row formula. :)