Download and assemble data from 51 states of US for 8 variables from google insights. When this is done you will have 51 files representing the 50 states in America and the district of Columbia
You now need to format the data that you downloaded. Start by assigning a unique number to each state 1….51. This should be the first column in your excel spreadsheet. The second column will be the name of the state itself.
The third column will be the year of the data.
Merge the files together: Country and time as row and variables as columns.