Transpose List in power query

Is there a way in Power Query to transform a list to layout vertically?

Column A are Agencies. Column B are sites they manage.
I would like the Agency's name to be headers and each site to be listed under its respective agency.

Code

Please Login or Register  to view this content.