Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate/VLOOKUP/Pivot Table?
Hi - I have a sheet of part numbers (tens of thousands of parts). Each part
has a part number, number of transactions, dollar value, etc... five columns of data for each part/row... six columns total in this sheet. I've been given a SECOND list of part numbers, with only one additional column: a Category with values of "Core" or "Non-Core". This list of parts is not identical to the earlier list... some of the same items are on both lists, some are only on one list. I need to create a single list with ALL the part numbers from both lists, and all data for each part. I've tried a pivot table, but the "Core" or "Non-Core" column shows up as 0 or blank. Thanks in advance. -- Grateful |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
consolidate data in pivot table | Excel Discussion (Misc queries) | |||
Consolidate Pivot table from multiple files | Excel Discussion (Misc queries) | |||
Using Pivot Table to consolidate multiple worksheets | Excel Discussion (Misc queries) | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
Consolidate data from several worksheets via pivot table | Excel Worksheet Functions |