Any advise on how to de dedupe each column for duplicate values
There is a way to do it with Gather, Dedupe, Spread and Slide.
But there is also a much simpler way with just Unfill and Slide.
Prashant.transform (5.5 KB)
You will need the latest snapshot for Slide.
Ps/ Please don’t forget to mark posts like this as ‘Question’.
From my point of view the “complex” solution is required. The simple one with Unfill wouldn’t work in case there is a sequence in one column like “X, X, Y, X”. The complex one is more robust.
You can ensure the original columns order by extracting just the headers (with filter) and adding a Stack transaction …
Prashant_2.transform (6.5 KB)