Power Query - Concatenate and Transpose

Question

I"ve a data table (1) below and want the result as in table (2). How can I do this?

Answer 1

I'd suggest the following:

• Delete duplicate rows using Remove Rows > Remove Duplicates
• Group your table using concatenation (see this question)
• Split the concatenated State column using Split Column > By Delimiter.