Forum Discussion
Pivot table problem (connected cells)
Hello, I am currently facing a problem with my pivot table in Excel. The data (base) table that I am using has some columns with connected cells and others that are separated. For the analysis, I ne...
You'll have to unmerge C9:C10 and repeat the value "Apple" in C10. Otherwise, your source data is not a real database-like table.
HansVogelaar
Yes, but is there another solution to assigning the properties (sweet & sour) to Apple? Because otherwise my amount of Apples in the table becomes untrue. The real table I am using is much bigger and the amount of entities in column B is of importance.
Yes, but is there another solution to assigning the properties (sweet & sour) to Apple? Because otherwise my amount of Apples in the table becomes untrue. The real table I am using is much bigger and the amount of entities in column B is of importance.
Add the source range to the data model when you create the pivot table:
You can then select Distinct Count as aggregation function for the value field:
Result: