Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
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.