Excel BI Power Query Challenge Workout 059

-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 59-
(Solution in any language also welcome for Power Query Challenges)

Generate the result table where -
Questions should be listed in headers.
First column will be listing Options 1, Options 2…
There will be a blank row before the last row
Last row will list the correct answers for those questions

Download Practice File - https://lnkd.in/dJiKcj4d

(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)

#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r

Excel BI’s LinkedIn POst