Hello
I want to separate a column to have 3 other columns as shown in the table below:
Depending on the type, I would like to separate values in the “Col to separate”
is what you posted above your desired output? If yes is it for reporting or for further analysis cause I don’t see why do you want this format and this empty rows… Do you always have 3 possible values or it can be more? Why do you start populating from last column? Do you have only integers in column you want to separate? Can you have missing values there or not?
I know it is a lot of questions but somehow you request is not clear to me…