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
Смотрите видео How to Analyze Survey Data Part 2 - Unpivot Column of Comma Separated Values онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel Campus - Jon 24 Март 2016, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 63,018 раз и оно понравилось 1.1 тысяч людям.