consolidating data

[Jungo]

Hi there,

I am having a hard time consolidating data based on multiple data points.

I am trying to get a total quantity of all like sizes of a component.

from this data set i should have:
3 components that are 9.5 x 5.5 x 1.5
39 components that are 9.25 x 5.5 x 1.5
6 components that are 16.75 x 3.5 x 1.5


the sizes and names and number of lines are always changing, but i am trying to figure out how to consolidate quantities when all columns match, except quantity.

any thoughts, help my brain out.

thanks!

Quantity	Description	Length(L)	Width(W)	Thickness(T)	Material	STATION	DONE
1​	PLATE - CRIPPLE	9.5​	5.5​	1.5​	SPRUCE	CORRIDOR
1​	PLATE - CRIPPLE	9.5​	5.5​	1.5​	SPRUCE	CORRIDOR
1​	PLATE - CRIPPLE	9.5​	5.5​	1.5​	SPRUCE	CORRIDOR
12​	PLATE - CRIPPLE	9.25​	5.5​	1.5​	SPRUCE	CORRIDOR
8​	PLATE - CRIPPLE	9.25​	5.5​	1.5​	SPRUCE	CORRIDOR
6​	PLATE - CRIPPLE	9.25​	5.5​	1.5​	SPRUCE	CORRIDOR
9​	PLATE - CRIPPLE	9.25​	5.5​	1.5​	SPRUCE	CORRIDOR
4​	PLATE - CRIPPLE	9.25​	5.5​	1.5​	SPRUCE	CORRIDOR
5​	PLATE - CRIPPLE	16.75​	3.5​	1.5​	SPRUCE	CORRIDOR
1​	PLATE - CRIPPLE	16.75​	3.5​	1.5​	SPRUCE	CORRIDOR

 

[alansidman]

Use Group By in Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Grouped Rows" = Table.Group(Source, {"Description", "Length(L)", "Width(W)", "Thickness(T)"}, {{"Total", each List.Sum([Quantity]), type text}})
in
    #"Grouped Rows"

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Quantity	Description	Length(L)	Width(W)	Thickness(T)	Material	STATION	DONE	Description	Length(L)	Width(W)	Thickness(T)	Total
2	1	PLATE - CRIPPLE	9.5	5.5	1.5	SPRUCE	CORRIDOR		PLATE - CRIPPLE	9.5	5.5	1.5	3
3	1	PLATE - CRIPPLE	9.5	5.5	1.5	SPRUCE	CORRIDOR		PLATE - CRIPPLE	9.25	5.5	1.5	39
4	1	PLATE - CRIPPLE	9.5	5.5	1.5	SPRUCE	CORRIDOR		PLATE - CRIPPLE	16.75	3.5	1.5	6
5	12	PLATE - CRIPPLE	9.25	5.5	1.5	SPRUCE	CORRIDOR
6	8	PLATE - CRIPPLE	9.25	5.5	1.5	SPRUCE	CORRIDOR
7	6	PLATE - CRIPPLE	9.25	5.5	1.5	SPRUCE	CORRIDOR
8	9	PLATE - CRIPPLE	9.25	5.5	1.5	SPRUCE	CORRIDOR
9	4	PLATE - CRIPPLE	9.25	5.5	1.5	SPRUCE	CORRIDOR
10	5	PLATE - CRIPPLE	16.75	3.5	1.5	SPRUCE	CORRIDOR
11	1	PLATE - CRIPPLE	16.75	3.5	1.5	SPRUCE	CORRIDOR
Sheet1