Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have an excel that stores multiple values in a single cell, separated by commas. I'd like to be able to pivot on each of those specific values. Is there a way to do this?

share|improve this question

migrated from stackoverflow.com Mar 28 '13 at 0:36

This question came from our site for professional and enthusiast programmers.

I'm afraid the only way to do this is to split the cell's content into multiple cells. –  Peter Albert Mar 27 '13 at 21:40
I found another way, though I will have to use multiple pivot tables. I can make the field with the multiple values as the report filter and then do a search for each specific term. It's ugly, but it works. –  Cameron Kremer Mar 27 '13 at 21:44
hard to imagine your solution, given that the purpose is not clear from your question - but as long as it works, good for you. If you don't mind, consider adding your own answer below, so others can benefit from your solution, too! –  Peter Albert Mar 27 '13 at 22:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.