Pivot Data Across Multiple Columns - 2 Step Dynamic Power Query Solution
This is Power Query Solution to Excel BI Challenge on LI - Align the names under their respective cities.
List of cities should not be hard-coded but generated from column B. Respective names under the city would come from column A.
Link to the Challenge - https://www.linkedin.com/posts/excelb...
Also checkout the other Amazing solutions as well.
