Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/

Checkout the full article and download the file at: http://www.excelcampus.com/pivot-tables/analyze-survey-data-in-excel/

Learn how to use Power Query to transform multiple choice survey data in Excel. This survey data has been exported to Excel in a format that is not easy to use for a pivot table. In this video you will learn how to use the Unpivot feature in Power Query to transform or normalize the data. This will make it easier to analyze with a pivot table and chart.

Please subscribe to my free email newsletter to get more Excel tips and tutorials like this. http://www.excelcampus.com/newsletter

PART 2: https://youtu.be/h-sKEPEvwZ8
PART 3: https://youtu.be/NBgL8ItVdKY