Excel Data Formatting

New Contributor

Hi, I am trying to format a set of data produced from an estimating program. I am trying to find a quick way to group like items, DH001 are the same item so I would like the Order (Quantity) of like items added together. The Cost Each left the same and the Price Total combine. Is it possible to format this way even through multiple tools. (Current using Consolidate tool to combined Item and Order (Quantity) columns effectively)

 

 

Screenshot 2022-06-07 145004.png

1 Reply

@James0610 Perhaps PowerQuery is what you need. See example attached where only the blue shaded range is used to create the green table.

Riny_van_Eekelen_0-1654677303244.png