PQ - table reorganization

table reorganization

Name	Fruit	Qty		Name	Apples	Bananas	Melon
John	Apples	7		Dave		3
Steve	Apples	4		John	7		1
Pete	Bananas	2		Pete	6	2
John	Melon	1		Steve	4
Pete	Apples	6
Dave	Bananas	3

Code:

---

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

---