Insert row when data changes

[jimmyhartington]

Hi

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

So output could be like this:

[Olaf]

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)

[Olaf]

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

[Admin]

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

[jimmyhartington]

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