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

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?

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


pkunAAC wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html