Hi
This is probably simple.
But I want to insert a blank row each time CHATID changes.
So output could be like this:
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)
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.