How to Analyze Survey Data Part 2 - Unpivot Column of Comma Separated Values
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
Checkout the full article and download the file at: http://www.excelcampus.com/pivot-tabl...
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: • How to Analyze Survey Data Part 1 - U...
PART 3: • How to Analyze Survey Data Part 3 - S...
00:00 Introduction
00:21 Split Column
03:44 Conclusion
Watch video How to Analyze Survey Data Part 2 - Unpivot Column of Comma Separated Values online without registration, duration hours minute second in high quality. This video was added by user Excel Campus - Jon 24 March 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 63,018 once and liked it 1.1 thousand people.