Power Query - Combining data

[sanket_sk]

Hi There,

I Have unique query on Power Query, I have below table in which Material Cost & Other cost are given in separate column against same PO but in separate rows.
I want to combine them and put it in single row, since the value can be available in any cell hence I am not using fill up / down function.

Sample Data ..

Order Number	Order Date	Material Cost	Other Cost	Misc
6000023680​	09-06-2023​	9840​
6000023680​	09-06-2023​		7630​
6000022591​	09-06-2023​		7458​
6000022591​	09-06-2023​	9960​
6000053387​	18-07-2023​			18422​

Result I am looking is

Order Number	Order Date	Material Cost	Other Cost	Misc
6000023680​	09-06-2023​	9840​	7630​
6000022591​	09-06-2023​	9960​	7458​
6000053387​	18-07-2023​			18422​

Could you please guide me steps in excel power query to achieve this.

Thanks & Regards,
Sanket

 

[RoryA]

You could just group on order number and order date and sum the other columns.

 

[JEC]

Like RoryA said

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    grp = Table.Group(Source, {"Order Number", "Order Date"}, {{"Material Cost", each List.Sum([Material Cost])},{"Other Cost", each List.Sum([Other Cost])},{"Misc", each List.Sum([Misc])}})
in
    grp