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.