I have data in 22 columns extending to various rows.

Is there a way to extract the Unique Records (to a new location) from all 22 columns at once like you can with the Advanced Filter?

(VBA is ok if there's no other way)