I'm creating a pivot table of a list of items that need to be ordered. Each Item has a model number and a description that remain consistent. The data is copied from another sheet and is formatted like this:
|Model Number |Description | ===================================== | | | | | | | | | |1234-5678-90 |Model A | | | | |1234-5555-90 |Model B | |1234-5555-90 |Model B | |1234-5678-90 |Model A | |1313-5678-90 |Model D | | | | | | | |1234-5678-90 |Model A |
The final result that I'm trying to achieve is a pivot table resembling this
|Model Number |Description |Quantity | ======================================================= |1234-5678-90 |Model A |3 | |1234-5555-90 |Model B |2 | |1313-5678-90 |Model D |1 |
But I can't figure out a way to do this without creating a multilevel table.