I need a macro to convert existing single rows of data where one column contains Comma Separated Values into multiple rows with the CSV broken out individually.
It needs to do this for each existing original row and then stop when there are no more original rows.
I've attached an example of the original data set (I'll have more columns in a final file but still just one column with CSV info to be broken out so I kept this example simple)
Tab 1 = Original Data
Tab 2 = After Macro Runs