Conversion of Columns into Rows with Group by Function

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 

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