Table.ToRecords

Transforms a table into a list of individual records.

Syntax

Table.ToRecords(table as table) as list

About

Transforms a table into a list of individual records.

Explanation

Transform the table into a list of records using the Power Query MTable.ToRecords function. This function takes a table created from rows of data, with each row containing values for CustomerID, Name, and Phone. The output will be a list of records where each record includes CustomerID, Name, and Phone information. The resulting records will be structured as follows: { [CustomerID = 1, Name = "Bob", Phone = "123-4567"], [CustomerID = 2, Name = "Jim", Phone = "987-6543"], [CustomerID = 3, Name = "Paul", Phone = "543-7890"] }