text to columns but in a neat way
Hello all,I have a column of character data set which consist of codes of discounts we give our agencies. Also there are rows with empty data (no discount)I would like to get a result as below without generating any additional row:
