Dynamically selecting and exporting grouped values from tables

[GuyHarveyj]

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

[binuacs]

@GuyHarveyj Would you be able to attach a sample file and expected output?

[GuyHarveyj]

sure 

[binuacs]

@GuyHarveyj One way of doing this with the Transpose and the Summarise tool

[binuacs]

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

[GuyHarveyj]

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

[binuacs]

@GuyHarveyj @This workflow should work