Analysis of caller IDs from different states across all campaigns for a certain company

A cold calling company asked me to analyse its caller ids companywide. They asked for in-depth analysis for the caller ids used across all campaigns they dial, wanted to know which DIDs are from which states, and how many of a certain ID did they use for a single campaign.

I used powerquery in excel to carryout this analysis.