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/

In this second part of the series we learn how to use Power Query to transform multiple choice survey data that is in a single column of comma separated values. 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 Split Column and Unpivot features 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 1: https://youtu.be/GJznCipDeg0
PART 3: https://youtu.be/NBgL8ItVdKY
00:00 Introduction
00:21 Split Column
03:44 Conclusion