I'm working with some data that is organized by case number, with a wide range of results in a couple of dozen columns. For some reason, I'm having an impossible time figuring out how to use this data with pivot tables or pivot charts. One reason might be because I have some data using 1 as a "yes" answer to some of the questions and it can't seem to recognize that and group them. Does anyone have any suggestions for what I'm missing or how I can use pivot tables with data in a format like that?
