(this can happen due to my dataset only 2 columns were unpivot). I have NO skill with VBA and the client I'm doing this for uses a Mac which apparently doesn't play very well with the Data Model.Hi at what you ask I believe that the best way is making the unpivot of the column(s) however I can understand the issues you are pointing out, although the question about the tooltip I'm not abble to replicate, when I used the unpivot colum on my chart it gave the exact same result on the tooltip as having all the column on the chart. Any ideas to make this a less manual process are welcome! Bonus if they aren't VBA or Data Model driven. I've attached a sample file with the Starting Data, Formatted Data, and Chart Result I need. This got the data into the format I needed it in to create the scatter graphs for a Hennessy-Hicks Training Needs Analysis. I used the data in the Pivot Tables for each question type entry. Created Pivot Tables for each question so I could get the averages of each response type.Ĭreated a new table with the question number, question name, question type, and average of each response type.Loaded this into a new table on a new worksheet.Pivoted the data so the rating types were in one column and the actual questions were now my header row.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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |