Forum Discussion
ksab23
3 years agoHelper I
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...
Anonymous
3 years agoNot applicable
I dont understand your expected output related to your question but, you should maybe add Pivots/ Unpivots then transpose
- ksab233 years agoHelper I
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 email 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