Insert row when data changes

Hi

This is probably simple.
But I want to insert a blank row each time CHATID changes.

So output could be like this:

The upper end has a empty row after last row, the Botton part has 1 transformation more but avoid the last empty row.

New rows.transform (5.2 KB)

2 Likes

just thinking on it, the bottom row solution leads to a problem when there are empty values in the CHATID column.

I would probably do it in the same way as @Olaf’s top solution.

Thanks.
That was exactly what I needed.
Learn something from this as well.

1 Like