Google Sheets VLookup
Combine data from various sources, perform data cleansing,  and combine relevant rows  using the State as the lookup value.