Question

You import a product catalog into Power Query. A column named Tags contains multiple keywords per product separated by semicolons (for example, "organic;gluten-free;vegan"). Reporting requires each individual tag to appear as a separate row so users can filter products by a single tag. Which Power Query transformation sequence produces the required result?

Accepted Answer

Use Split Column by Delimiter (semicolon), selecting the option to split into rows

Answer

Use Split Column by Delimiter (semicolon), selecting the option to split into columns, then group by product

Answer

Use Extract > Text Before Delimiter to keep only the first tag

Answer

Use Unpivot Columns on the Tags column