Record.ToTable Function in Power Query

The Record.ToTable function returns a table that has two columns Name and Value, and it contains the field names and values from an input record.

Syntax

Example:

Power Query M

let
  source = [CustomerID = 1, Name = "Ashish", Phone = "123-4567"], 
  Return = Record.ToTable(source)
in
  Return 

The output of the above code is shown below: