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!
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 |