Wednesday, July 30, 2014

yogi_Consolidate Table Of Quantities And Parts Description By Part Numbers

                           Google Spreadsheet   Post  #1716
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul-30-2014
post by Steve G Horning:
Write a query to consolidate duplicate part numbers in a bill of material
I have a bill of material that has duplicate part numbers and I want to consolidate the quantities in column B for the duplicate parts.  The spreadsheet linked below has an example.  The Red area is before the consolidation and the Green area is the result I'm looking for.  I'm trying a query for the first time and I probably have some syntax wrong.  Any help would be greatly appreciated.

=query(A:E,"select * Sum(B) group by C order by A",1)