(Solved) – Excel for Mac v16.33 Comma Delimited Row Values to Stacked Column

  • by

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.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *