Forum Discussion
Solved
Transpose
Hi All, I would need some help with transposing data and for the life of me, I cannot figure it out. The dataset sample is attached. I need to transpose questions of the survey, answers, and scor...
I dont understand your expected output related to your question but, you should maybe add Pivots/ Unpivots then transpose
Hi, my expected outcome is this (below) and I cannot make it work really with pivot/unpivot and transpose. No matter what combination I try, it always gives me a messed-up result. So I know what to use but not exactly how if that makes any sense
| name | course Title | Course ID | date | I am likely to change my behavior following this training. | The design and duration was appropriate for the topic. | I would recommend this course for someone in my role. | |
| Agree | Agree | Strongly Agree | |||||
| Strongly Agree | Strongly Agree | Strongly Agree |