Table.ToRows
Generates a hierarchical structure of lists derived from the table named "table". Each item in the list represents a row of values within an inner list.
Generates a hierarchical structure of lists derived from the table named "table". Each item in the list represents a row of values within an inner list.
Generate a list of row values extracted from the provided table using Power Query M language. The table consists of records containing CustomerID, Name, and Phone fields for three customers. The output will be a list of lists, with each sublist representing a row from the table in the following format: {CustomerID, Name, Phone}. The final output will show the row values for each customer in the table as follows:
{1, "Bob", "123-4567"},
{2, "Jim", "987-6543"},
{3, "Paul", "543-7890"}.