I’m wondering if there’s a way to remove duplicate rows within a worksheet. I’ve used the rankdense formula on a calculated concatenation column so all dupe rows have the same rankdense # but now i’m not sure how to remove those
You can apply an exclude filter on that rankdense #.
Generally, reducing of duplicates is easier to do in a SQL of a source query (meaning using the SQL runner as your query source). You can even build datasets on top of datasets, if you need to dedup more than once.
Using pivots is another way to reduce duplicates. Or you can create a level and them hide all the base columns,