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.