Power Query Grouping Lists displays

Hola,

I seem to have my code incorrectly written and was hoping someone could ID my error.

Blue table is my original data. Green table is results based on my current codes. Orange table is my desired output.

Providers can have multiple addresses. I need for all addresses to be merged together in one cell next to the associated provider in below format:

Address 1; Address 2; Address 3......

However, my results in green table are pairing cities together, states together and zip together.

try this

Please Login or Register  to view this content.

That didnt work. Can you add that to my workbook sandy?

what didn't work? Could you be more descriptive?

I had accidently added a comma but it did work. Thankyou sandy!

thanks Alan

Originally Posted by JyothiGrace

I had accidently added a comma but it did work. Thankyou sandy!

You are welcome, hope it works for you