Hi there -
I have a code that will do this for a specified column that I’ve included below. It currently only works for one column which I specify column in the code (column 3). I need it to evaluate each column sequentially to separate all comma-separated data column-by-column. For example, the macro needs to look at column one, separate the list, and then take that output and separate it based on column two. It keeps going through the columns until there are no more columns.
The attached workbook shows an example of what I want the output to look like for a given input.
My suspicion is that I need to put a loop in a loop but honestly have no idea how to do it. Any help would be greatly appreciated!
Thank you!
Current code:
Bookmarks