You are pulling the data one state at the FIPS level a time - thats a lot of data - each state is a separate sheet -
If you actually need all the data suggest you put them into a common excel file and use a wildcard union to append the data into a single file
see the link Union Your Data
If you don't need to go that level and the state level is adequate the first row in each file will be the state total and you can purge the remaining data before creating the wild card union
In any event once you get the data into a single file you will want to pivot the data into a long thin file vs a wide file so you can work with data
Tableau Prep would make the job easier
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you Jim for the reply,
but please bear my stupidity, i still don't know what to do next.
I know union, but it seems that the data still doesn't make sense to me. Like column B1001001, 002..... and so on, they should be something else more meaningful, and i don't see any geo data in the file at the moment.
would anyone please help?
guys please assist.