Forum Discussion
Adding transposed columns into new Table
Hi all, I've set up an MS Forms that records responses from users in the below format: ID DateTime Mail Value1 Value2 1 10/10-2020 15:37:14 [email protected] Yes No 2 10/1...
Anonymous , I think you have to unpivot all the columns.
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Anonymous , I think you have to unpivot all the columns.
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Hi amitchandak,
Thanks for the quick feedback!
I've dabbled with unpivotting the dataset before without getting the wanted outcome, but this seemed to do the trick1
Thanks!