I have 20 or so spreadsheets with names, address, city, state, zip all combined into various cells. Some have first and last names in one column, some have city, state, zip in another column. So are comma separated, some are space separated. It just varies. Each of these data sets come from different counties.
I need them all separated into columns like this "FirstName" "Last Name" "Street Number/Name" "City" "State" "ZIP" "value" "acres"
I need them organized into just one excel spreadsheet, but still each data set is separated by tabs at the bottom and named after the original file.
ok, can you share me the spreadsheet? just want to ask if the structure of the columns of 20 spreadsheets are same? or different? if same then all can be merged after separation easily, waiting
Hi, I am expert in excel and interested in this project, let me do this work with perfection, accuracy and according to your requirements, plz contact with me so we can discuss further about the project