I’ve been looking for an answer to this all over and found a solution using power query which is not compatible with my excel for mac version. I have a list of delimited values, and I have to put them into a stacked column on excel.
It’s much easier to explain in an image so I have attached a simplified example of what I have and what I need. The values are in the hundreds of ID#’s with comma delimited values up to 10, with a ton of characters in each, so copy paste > transpose won’t work.
Please let me know what I can do!
Thank you in advance.