I have data that contains full state names and acronyms.
In 'Edit Locations' - both are the set to the same matching location:
TX = Texas
Texas = Texas
However, data on my map is still separated between TX and Texas.
EX. Pie chart on map for sum of sales in Houston - shows separate pieces for Houston TX as $1M and Houston Texas as $2M
I need the data to combine as one state.
When I 'Edit Locations' - do these edits remain valid if I create a new worksheet?
1. You should group the locations so that they don't show up as 2 different values.
2. Yes, the locations will remain valid.