I need to separate data in column B that has a comma separating the numbers into one column and keep the value of column A tied to the data being separated. The new data needs to go to a new sheet. I have attached a sample what is needed.
Sample.xlsx
Bookmarks