Adjacent rows in a field should not be same

[Data_Alter]

Hi I am building a larger workflow where I don't want adjacent rows for the account number column should not be same

Basically if the dataset looks like this

Document Number	Account Number	Amount
d	1000	5.00
d	1000	-       5.00
d	2000	-       5.00
d	2000	5.00
e	8000	10.00
e	8000	-     10.00
e	8000	10.00
e	8000	-     10.00
e	9000	-     10.00
e	9000	10.00
e	9000	-     10.00
e	9000	10.00

It should look like this

Document Number	Account Number	Amount
d	1000	5.00
d	2000	-       5.00
d	1000	-       5.00
d	2000	5.00
e	8000	10.00
e	9000	-     10.00
e	8000	-     10.00
e	9000	10.00
e	8000	10.00
e	9000	-     10.00
e	8000	-     10.00
e	9000	10.00

[BS_THE_ANALYST · Accepted solution]

One way to do this:

[FinnCharlton · Accepted solution]

Hi @Data_Alter , I would approach it like this:

[binuacs · Accepted solution]

@Data_Alter One way of doing this