I have Excel 2013 and the latest version of Power Query.

I am using Power Query to import the attached CSV file by each individual State (Column Labeled "Provider Business Practice Location Address State Name" which goes into Column AF after being imported) and then saving it. I have to do this each time 50+ times for each State or territory as, although this CSV file is only 13,667 rows, I have another CSV file just like this one that is 5 million rows and cannot fit into one Excel Sheet.

Is there a macro that can automatically import and save 50+ Excel files grouped by each unique value in that column? I would imagine the macro would interact with Power Query, but if it could do it without Power Query, that would be fine too..Thanks.

Providers.zip