Pivot more than one column in Power Query?

[generalledger]

Is it possible to pivot more than one column?

I can pivot on RespTypeName and sum Amount = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[RespTypeName]), "RespTypeName", "Amount", List.Sum) which works as hoped.

I can pivot on RespTypeName and list (Don't Aggregate) to show the text InsuranceName = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[RespTypeName]), "RespTypeName", "InsuranceName") which also works as hoped.

I want to perform both transformations so I have a column for Amount and a column for InsuranceName for each RespTypeName. Possible???

Thank you very much for your attention.

General Ledger

 

[AliGW]

Possibly. Attach a sample file.

 

[Rudi]

Is it possible to pivot more than one column?

I can pivot on RespTypeName and sum Amount = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[RespTypeName]), "RespTypeName", "Amount", List.Sum) which works as hoped.

I can pivot on RespTypeName and list (Don't Aggregate) to show the text InsuranceName = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[RespTypeName]), "RespTypeName", "InsuranceName") which also works as hoped.

I want to perform both transformations so I have a column for Amount and a column for InsuranceName for each RespTypeName. Possible???

Thank you very much for your attention.

General Ledger

I could be wrong, but it sounds to me like you need grouping instead of pivoting...
Place the following line after the #"Sorted Rows" and see if it provides something useful?

    #"Grouped Rows" = Table.Group(#"Sorted Rows", {"RespTypeName", "InsuranceName"}, {{"Amount", each List.Sum([Amount]), type number}})