Hi,
in the macro I sent you, all you have to do is to change the "Important parameters" to the following values:

FirstRow = 14
StateColumn = "AB"
DataSheet = "original"

When creating the pivot table, please mark the cells AB13:AB65535.
Then create the pivot table as explained above and just follow the previous instructions. The macro will take some time to run, but it worked when I tested it on your complete file.

Kind regards
Bjorn