Power Query: Split Text into Rows and Columns with One Click
In this Power Query tutorial, we solve Challenge 83, where we split a text column into new rows and columns in a single step using List.Transform. This method allows you to restructure your data efficiently by extracting values from text and splitting them dynamically.
🔹 Topics Covered:
Using List.Transform to split text into multiple rows and columns
Transforming text data for easier analysis
Handling complex text patterns and dynamic splits
Optimizing transformations for large datasets
This approach is ideal for dealing with delimited text, unstructured data, and turning text into a structured format for reporting and analysis.
Have another technique? Share it in the comments! Don’t forget to like & subscribe for more Power Query challenges.
00:00 Introduction
01:00 Power Query Editor
02:06 Solution 2 using M