Hi, I set up a table where I list stores by city & state.
I’d then like to group the store list by individual state.
As you can see in the link below it is creating a grouping not only by “NEW YORK” & “CALIFORNIA” but also by “CALIFORNIA, NEW YORK”....
Hi Elias, Thanks for your help.
I understand your recommendation.
Some of the stores have more than 1 location.
In the example link “Johns Store” has a location in NYC and also Los Angeles.
I was hoping to be able to keep each store as one record. Is...
