Hey Brew,
Do you really need a macro?
If not, you could....
Select your range (BQ5:BQ18)
Then go to Data > Advanced Filter > Copy to another location
Specify your range, BQ5:BQ18
Copy to: CH5:CH18
and so on for each columns....
Check mark the Unique Records at the bottom....
See if this works for you...
I know there's a better way, but this will get you started...
Cheers,
Sprucy