Arranging Online Survey Data with Unpivot in Power Query and Pivot Table

In this video, I will show you how I arrange the online survey data example that I have using the POWER QUERY unpivot other columns, PIVOT TABLE, and simple Conditional Formatting.

0:00 Intro
1:45 PQ Unpivot other columns
2:27 Pivot Table Report
3:28 Conditional Formatting

Watch the whole video for further explanation on the process!

Visit my channel: https://www.youtube.com/c/LinethDelaC...

Link to download the sample file:
https://www.dropbox.com/s/thqnvhvamgz...

Link on Playlist: Learn Spreadsheet Power Query:
   • Combine 3 workbooks using the Append ...  

Thanks for your time and I hope you learn something from it.

Help me to reach my target audience by sharing my videos with the right people.

Don’t forget to Subscribe!