Creating a list (not columns) of comma separated values
I have a list of words (comma separated values) and want to know how to separate these words onto separate lines in the same column e.g. in column A line 1, 2, 3, 4, etc.
If you don't need a dynamic solution, you can also use "text in columns" and transpose. See my attached video. I created my video with Excel for the web.
