Hello,
I have a cell which has data separated by "_" for example _11_G_1_B_0_0_, I need to separate this data. It will split as 11, G, 1, B, 0, 0, (Blank Cell), next set of 6 cells and a blank cell again. After the split I want to cut every 6 rows and align them under each other. The 0's must be blank and finally a column inserted after the first cell. Example attached...


Thanks!
SplitCell.xlsx