Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

I used to rely on Excel's Remove Duplicates tool like a reflex, but it's actually a dangerous, destructive, dead-end process that leaves no visible audit trail. So, I've switched to the UNIQUE ...