I have five columns of text containing state abbreviations. I need to count the number of times (out of 5) each abbreviation occurs in the row and show the result for each state in a separate column (i.e. State 1, State 2, State 3,...). Any help will be greatly appreciated. I have attached an example and included a list of the state abbreviations.
Bookmarks