I have a workbook containing some data. Some of the columns contain more than 1 data put together in 1 cell. Now I have responsibility to separate them and make a new sheet with each item in its own column.
The sheet contains 11 columns
Columns 2, 4, 8 and 9 contain mixed entries