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...
Can't quite visualize what you're describing. Is it possible for you to post a copy of the file, if not here in this forum then on OneDrive or GoogleDrive or equivalent. Grant access and post a link here.
Thanks for the quick reply. I created a simple case example in Excel. I hope this explains the problem better. When you download the file as an xlsx file, you should be able to access the pivot table.
https://docs.google.com/spreadsheets/d/1iPFVkumobGhTNVj2-mN_42Jm-OjA7ImQ/edit?usp=sharing&ouid=110384672363907143767&rtpof=true&sd=true
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.
