Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717

Posted on by Bb

Download Excel File: https://excelisfun.net/files/EMT1717.xlsx
Download Text File: https://excelisfun.net/files/EMT1717RecordsInColumn.txt
Learn how convert a column of records into a table using Power Query with a User Interface Method and an M Code Method.

Topics:
1. (00:00) Introduction.
2. (00:20) Coffee Introduction
3. (00:34) Teammates.
4. (00:54) Why use Power Query?
5. (01:03) User Interface Method.
6. (03:12) Edit a query. We need to fix data types.
7. (03:42) M Code Function Method using List.Split and Table.FromRows functions.
8. (06:24) Summary
9. (06:41) Closing and Video Links

ExcelIsFunTue, August 10, 2021 3:08am