I have exported data from SharePoint to Excel 07. Some of the data comes from a checkbox field, and thus has multiple entries. Once exported, these are broken out with semicolons and hash signs. Is there any way to break out this data into my PivotTable so that I can count separately whenever each entry is selected? To give a solid example, in the attached image, how would I count "PRS Training/PRS Demo" multiple times? Thanks!
Bookmarks