Table.ToColumns

Table.ToColumns is a Power Query M function that creates a list of nested lists from a table, where each list item is an inner list that contains the column values. The function returns a list of lists representing the columns and their respective values.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Table.ToColumns( table as table ) as list

Description

Creates a list of nested lists from the table, table. Each list item is an inner list that contains the column values.

Examples

Create a list of the column values from the table.

// Output: {{1, 2}, {"Bob", "Jim"}, {"123-4567", "987-6543"}}
Table.ToColumns( 
    Table.FromRecords( {
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"]
    } )
 )

Related articles

Learn more about Table.ToColumns in the following articles:

• Get Value from Previous Row using Power Query
  This article shows how to get the previous row value using Power Query. You can adjust the 3 ways to also retrieve an earlier or later row. » Read more
• Replace Values in Power Query M (Ultimate Guide)
  Learn how to replace values in Power Query. Look into conditional replacements, replacing in multiple columns, case sensitivity and more! » Read more

Related functions

Other functions related to Table.ToColumns are:

• Table.Partition
• Table.PartitionValues
• Table.Split
• Table.SplitAt
• Table.ToList
• Table.ToRecords
• Table.ToRows
• Table.Transpose

Last update: August 25, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/table-tocolumns
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.