Forum Discussion
Changing table values to headers
Hi, I have a set of data that looks like the below; ConfirmationId Answers.Questions.QuestionName Answers.TextAnswer 330478 BOOKING REQUEST DATE 17.01.20 330478 CANDIDATE EMAIL (NC...
Fortunately for you, this will still work, even on text 🙂
Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.
Tadaaa 🙂
Jaap
Fortunately for you, this will still work, even on text 🙂
Just select your second and third column. Then do pivot, in advanced options choose MAX instead of COUNT and in your "values" column use your Answers.textanswer column.
Tadaaa 🙂
Jaap
Perfect!
Thankyou all.