Summarize GroupBy as New Columns

[Anonymous]

I have a set of customer data with each individual metric being recorded as a new record. How do I summarise this as a new table with columns for each metric. I have illustrated this below.

Customer	Type	Value
A	Cat.1	230
A	Cat.1	45
A	Cat.3	175
B	Cat.1	260
B	Cat.2	125
B	Cat.3	60
C	Cat.2	95
C	Cat.2	230
C	Cat.3	245

Row Labels	Cat.1	Cat.2	Cat.3
A	275		175
B	260	125	60
C		325	245

[v-juanli-msft]

Hi @Anonymous

Select "Type" and "Value" columns, select "pivot columns",

“

Community Support Team _ Maggie Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

“

Best Regards

Maggie 

[HotChilli]

I agree.  Pivot on Type and use the Values column for values.  Do this in the Power Query Editor

[Anonymous · Accepted solution]

Hi,

It looks like Pivot https://community.powerbi.com/t5/Community-Blog/Pivot-your-Data-using-Power-Query/ba-p/224019 is what you need

Best,