I tried to simulate my date with the following table. But what I want out of it is three records containing City & State.
e.g. Lets original data will look like,
and what I expect finally is:
Could you please help me get a query or suggest something?
I used a table instead of JSON for display pupose