Grouping multiple columns in Power Query

[hideakisuzuki01]

Hi,

I am trying to GROUP BY the following data

Prod	Mat A	Mat B
A	A-1
A	A-2
A		A
B		B-1
B		B-2
B		B-3
B	B
C	C-1
C		C-1

into this one below.

Prod	Mat A	Mat B
A	A-1
A	A-2	A
B		B-1
B		B-2
B	B	B-3
C	C-1	C-1

Is this possible ?  I thought I could do it using Power Query but 

I cannot figure out how.

Can anyone please help ?

[hideakisuzuki01]

Thanks !

[some_bih · Accepted solution]

Hi @hideakisuzuki01 check link below, you can group ony or more columns. I hope this help

https://learn.microsoft.com/en-us/power-query/group-by