Forum Discussion
Multiple values in each cell
Hello all! I have recently downloaded data collected from a questionnaire but I notice that I have several values in each cell. How can I ... 1. Convert each 'new line' of value to it's own ...
Jenniferg980 I believe you need a Power Query solution for this. If you are open to such an approach, please have a look at the attached file.
The key element here is to split column B using a line feed as the separator. Then unpivot the table, and in the end, group a single column counting all occurrences of all levels.