Hi
I have a column with string, integer and blank rows. I want to split the string and add data row below it.
Here is the sample file Book1.xlsx (11.7 KB)
example:
input: 2345
100 promo,104 promo,108 promo
output : 2345
100promo
104 promo
108 promo