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.