Unique Value from each field with counts from CSV

Question

Hi Friends

I've been trying to work out this problem for hours and I'm getting nowhere.

I have a CSV file with a series of columns (30+) as the field names. Each field has values in it, where it maybe duplicates or not.

Eg - This is a cut down version

For each field, I want to list all the unique values and the record counts for each one, for each field.

Basically I'm trying the get a summary of whats in each field and the counts that go with each unique record per field

This is what I'm trying to get

I'm hoping someone could help me.

Many Thanks

Paddy

JosephSerpis · Accepted Answer

Hi @Paddydd I mocked up an approach on how to tackle this approach using the methodology I mentioned.

Paddydd · Accepted Answer

Hi Joseph - Thank you so much. You are a genius. Thats exactly what I wanted.