Grouping/ Pivoting Survey Data

Hi BI Community,    I need your help! Here is what I am dealing with:  1. Survey Data 2. 64 questions 3. 8 Categories 4. Each question is part of one of the categories.    I want to create a...