Dynamically selecting and exporting grouped values from tables

Question

I've got a load of tables that need to be profiled and sent back to users for some data cleansing. I'm trying to compile a grouped list of the values in a range of fields with a table and the record count of each value.

My based data (selected fields only) from my first table looks like this;

and my initial output looks like this so I export to separate tabs in Excel

I have built this for 1 table but as I have loads of tables to profile this could be a laborious process, is there a more dynamic way to do this?

Thanks

Guy

binu_acs · Answer

@GuyHarveyj @This workflow should work

GuyHarveyj · Answer

No, the data will be coming from a SQL server, and all the tables will be different

binu_acs · Answer

@GuyHarveyj The above solution is for one csv file, do you want to perform the same functionality in multiple CSV files?