I have below table where some rows have duplicates. I need to get this reduced up to 3 rows as the transaction date has three different values. Also, I need other date from the other two columns as well.
Please note that I used duplicate rows filter for all columns but it did not give me what I was expecting as every contains something unique compares to the other rows.
you can try group loop and then inside build logic which in one iteration takes row where itβs 1 under document line column and in next it takes row where itβs 2 under it.