

July 16, 2010

Hi Damian,
You have filtered the column in the TIPT query for rows that 'equal' TIPT. Power Query is only finding exact matches, not any instance of TIPT along with other text. If you change the filter to 'contains' TIPT, then you get all the rows.
I must say, entering multiple values like this in a single cell is not how Excel is intended to be used. You will most likely come across other roadblocks when formatting your data like this. Ideally you should be structuring your data in a tabular format.
To fix the layout, you can use the Split Column by > Delimiter with the #(cr) custom delimiter and choose 'rows' under advanced options. This will create a separate row for each value selected in the drop down list in column A.
Mynda
1 Guest(s)
