Power Query: Transform Rows into Structured Table with Table.Split & List.Transform
In this video, we tackle Challenge 232, where raw data is presented in a vertical layout — with field names and values alternating across rows for each product. The task? Convert this unstructured format into a clean, tabular structure.
🔍 Problem Overview:
Each product has rows like:
A Code, 1160, A Name, Orange
...and so on. Your job is to pair each field name with its corresponding value, then pivot it into a structured format.
💡 What You’ll Learn:
How to split a table using Table.Split into structured blocks
How to reshape rows with List.Transform and turn field-value pairs into records
Techniques for converting vertical row-pairs into clean columns
Tips for handling inconsistent row layouts in real-world data
📊 A perfect solution for anyone dealing with exported reports, system logs, or messy row-pair structures in Power Query or Power BI.
🔑 Search Keywords: Power Query transform rows to columns, Power Query Table.Split, List.Transform tutorial, Power BI row to column transformation, M code examples, structured table from vertical layout, Power Query data cleanup
#PowerQuery #PowerBI #Excel #TableTransformation #Challenge232 #ListTransform #TableSplit #DataCleaning #PowerQueryTips #VerticalData #PivotRows #UnpivotToStructured