Hello,
I'm looking to create a macro that will sift through the data in column B and identify any commas. When the macro encounters a comma, I need it to insert a new row, copy the value of Column A down and break out Column B.
I've attached a sheet with a before example in columns A & B and an example of what I'm looking for in columns I & J.
Please let me know if this can be done.
Thanks!Book2.xlsx
Bookmarks