This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am new in creating pivot table. I tried a simple case of creating a pivot table to count types of fruits in two different baskets. My original table is
| Basket1 | Basket2 |
|---|---|
| apple | apple |
| apple | apple |
| orange | orange |
| pears | pears |
| pears | mango |
| mango | mango |
When I created the pivot table, I see the first column values are correct but the second column is incorrect. The Pivot table is as below,
the second column is copy of first column.
| Row Labels | Count of Basket1 | Count of Basket2 |
|---|---|---|
| apple | 2 | 2 |
| mango | 1 | 1 |
| orange | 1 | 1 |
| pears | 2 | 2 |
| Grand Total | 6 | 6 |
Pivot table fields are
What am I doing wrong?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
HI,
For better assistance, you may post your concern here. Just select Community > Forums > View All > Type in “Excel” then select the appropriate category.
Feel free to contact us if you need assistance with Windows.