Forum Discussion
Collapse duplicates and only keep those values for which the values align
Hello all, I'm trying to achieve something fairly straightforward, but might be a bit tricky to explain. I've been using multiple table copies and vlookup in excel to do this, but I'm hoping there...
lbendlin
Super User
Super UserThat doesn't sound like a scalable approach, assuming you will want to test for other combinations too.
I would ditch all the flag columns and implement this purely based on the fact table and an appropriately structured reference table.