Split Comma-Separated Values into Rows in Power Query
In this Power Query tutorial, we transform a table where multiple values appear in a single column.
Example:
Level → Level 1,3
The goal is to split these values and expand them into multiple rows, producing a normalized structure.
In this video you will learn:
• How to split text values in Power Query
• How to expand lists into rows
• A dynamic method to normalize tables
• Techniques for real-world data cleaning
This transformation is extremely useful when preparing messy datasets for Power BI or Excel analysis.