Did a Text to Columns followed by Dynamic Rename and used select to change Type to Double on Data 2. Replaced commas in Data 1. Joined data. Summarized twice, one by year and another by state. Used 4 Joins. Sorted data and renamed and reordered columns.