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.
HI, I would like to see files first, but I have experience in such jobs so this should be feasible. Please check my profile and contact me if you're interested. Thanks
Hello, I just have a quick question for you when you have time. On each spreadsheet, approximately how many entries are there? I can get started on this right now. Thanks, Tiffany