Forum Discussion

Helper II

1 year ago

Solved

Conversion of Columns into Rows with Group by Function

Hi,

I have been working on one report where I need to conver columns into rows and make that rows as Header.

This is what I have:

This is what the result should look like

Any help or suggestion would appreciate it.

Thanks in Advance for your inputs.

Hi,

Please try to use Table.Pivot M code.

Table.Pivot - PowerQuery M | Microsoft Learn

let
    Source = source,
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[field1]), "field1", "field2")
in
    #"Pivoted Column"

MasonMA
1 year ago
damit230183

Hi, you can pivot the column through Power Query UI as well:
1. Select Field 1 column, under Transform click Pivot.
2. In Pivot window, Select 'Field 2' for Value Column and 'Dont aggregate' for Aggregate Value Function.
Hope this makes it simpler:)

3 Replies

damit230183
Helper II
1 year ago
Thank you both for your response.

Both solution worked perfectily as expected.

Thanks

Super User

Hi,

Please try to use Table.Pivot M code.

Table.Pivot - PowerQuery M | Microsoft Learn

let
    Source = source,
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[field1]), "field1", "field2")
in
    #"Pivoted Column"

MasonMA
Super User
1 year ago
damit230183

Hi, you can pivot the column through Power Query UI as well:
1. Select Field 1 column, under Transform click Pivot.
2. In Pivot window, Select 'Field 2' for Value Column and 'Dont aggregate' for Aggregate Value Function.
Hope this makes it simpler:)