group & summarize diff rows of data that have something in common

[Guest]

I am trying to arrange a large amount of data (inventory) in 2 different
ways. 1) Group all identical parts into one row and 2) Group all identical
locations into one row. I dont know how to do this. I am dealing with over
3,000 rows. Any suggestions?

 

[Debra Dalgleish]

Depending on your workbook layout, you may be able to use a pivot table
to summarize the data. There are instructions in Excel's Help, and Jon
Peltier has information and links:

http://peltiertech.com/Excel/Pivots/pivotstart.htm