Forum Discussion
Aggregating data from multiple columns/rows to create a list
I need to create a list that looks at the data from B4:E12 (Cities) and identifies each unique city. In this case the "Cities List" on sheet-3 should OMIT the blank cells and only show Chicago, Detro...
You can try Power Query. In the attached file you can add dates and cities in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh in order to update the green result table.