| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
| How to plot only visible autofiltered rows in a data list | Charts and Charting in Excel | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Calculate cell row and column | Excel Discussion (Misc queries) | |||
| Controlling odd even rows when pasting data | Excel Discussion (Misc queries) | |||
Hybrid Mode
