Quick way to determine number of unique values per column

I have a dataset with over 400 columns... and long story short, there are basically duplicate columns (4 different formats for each field) and I want to select the ones where there are actual values (as opposed to blanks or nulls). Is there a quick way to do this in Domo without manually having to go through?

Maybe via Sumo card....?

I'd like to be able to export a spreadsheet with all the column headers and number of unique values for each.

Answers