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