Does anyone know how to accomplish this?
A pivot table counts the values as stored in the database (multiple values concatenated, separated by commas), I want to count them individually.
In this example, the counts should be as follows:
Value 1 = 3
Value 2 = 2
Value 3 = 3
Best answer by lauraj46View original