![]() Split the question column so I could get the actual question and the rating type (A, B, C, D) into another column.Unpivoted the data so my questions were all in one column and the answers were all in another and removed all open-ended responses.I took the exported data from SurveyMonkey and made it a table. Then I put the table into PowerQuery. Ultimately I will be using this data to create a chart like below. I'm thinking I may need to do more Pivot/Unpivot work but not sure what columns to apply those steps to. I have Pivoted/Unpivoted the data in Power Query and have gotten close (see image attached) but I know I am still missing something because for my 10 test responses I have 380 rows. There are 39 questions I have that this applies to and then 10 that are open-ended responses. What I need to get is the questions all in one column with the A-D responses as their own columns (just like it would have been setup on the survey, but consolidated) without generating hundreds of rows or columns per respondent. The others gave me errors that I don't know how to fix - which is really sad because I was really looking forward to getting all of the questions onto one tab. Unfortunately, the only parts that worked for me were the "Data Transform" and the "Make Pivot Tables" macros. That was helpful, and I can certainly work with what it gave me. You're correct - definitely a Survey Monkey download. Excel for Customer Service Professionals.
0 Comments
Leave a Reply. |