Table.DemoteHeadersTable.DemoteHeaders

SyntaxSyntax

Table.DemoteHeaders(table as table) as table

InfoAbout

Stuft die Spaltenüberschriften (d. h. Spaltennamen) zur ersten Wertereihe herunter.Demotes the column headers (i.e. column names) to the first row of values. Die Standardspaltennamen lauten "Column1", "Column2" usw.The default column names are "Column1", "Column2" and so on.

Beispiel 1Example 1

Stuft die erste Zeile mit Werten in der Tabelle tiefer.Demote the first row of values in the table.

Table.DemoteHeaders(
    Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"]
    })
)
Column1Column1 Column2Column2 Column3Column3
CustomerIDCustomerID NameName PhonePhone
11 BerndBob 12 34 56 7123-4567
22 KlausJim 98 76 54 3987-6543