PQ - table reorganization

[sandy666]

table reorganization


NameFruitQtyNameApplesBananasMelon

JohnApples
7Dave
3

SteveApples
4John
7
1

PeteBananas
2Pete
6
2

JohnMelon
1Steve
4

PeteApples
6

DaveBananas
3



let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
Pivot = Table.Pivot(Source, List.Distinct(Source[Fruit]), "Fruit", "Qty", List.Sum)
in
Pivot