Transpose Table and Keep Headers in Power Query M

Flips rows and columns while preserving the original column names as a new first row.

Table TransformationsIntermediatetransposerowscolumnsreshape

Power Query M code

let
    Source = YourTable,
    ColumnNamesAsRow = #table(Table.ColumnNames(Source), {Table.ColumnNames(Source)}),
    Combined = Table.Combine({ColumnNamesAsRow, Source}),
    Transposed = Table.Transpose(Combined)
in
    Transposed

Notes

Table.Transpose alone discards column names; this inserts them as a row first so they end up in the transposed output.

Requirements

A table you want to flip into a rows-become-columns layout.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

Related Power Query M snippets

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Transpose Table and Keep Headers.