In the attached excel file, first row is the sample output. 3rd column has all the states separated by comma and each state has a corresponding region. I need to be able to identify regions of each state and put it in the regions column. if more than 1 state is in the same region, 'Northwest' for example, just put 'Northwest'.
I hope I make sense.