Transpose values Power Query

**JyothiGrace** · 07-11-2021, 09:57 PM

I am trying to transpose distinct row values to column header using power query. Any help would be appreciated. Thank you!

**Bo_Ry** · 07-12-2021, 01:17 AM

Please try

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    DuplicatedColumn = Table.DuplicateColumn(Source, "Data.Service", "Copy"),
    PivotedColumn = Table.Pivot(DuplicatedColumn, List.Distinct(DuplicatedColumn[Data.Service]), "Data.Service", "Copy")
in
    PivotedColumn

**JyothiGrace** · 07-19-2021, 08:48 AM

Thanks Bo_Ry

Transpose values Power Query

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Transpose values Power Query

Re: Transpose values Power Query

Re: Transpose values Power Query

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Power Query connection only and extract values

[SOLVED] Transpose from columns to rows with Power Query

Requesting help for adding values in power query.

[SOLVED] How to loop through values using Power Query?

[SOLVED] Power Query - excel formula translation into Power Query

[SOLVED] How to add an Excel formula code into Power Query or create a new one in Power Query

Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions