Conversion of Columns into Rows with Group by Function

[damit230183]

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.

[Jihwan_Kim · Accepted solution]

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"

[damit230183]

 Thank you both for your response.

Both solution worked perfectily as expected.

Thanks

[MasonMA · Accepted solution]

@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:) 

[Jihwan_Kim · Accepted solution]

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"