What are the data like in your column ?
Does they get a separator like / or ; or whatever ?
You should share a piece of example of what your excell column look like
for example , if your excell column named My_column get this kind of data :
John / 28 / Seatle ( where you have a name , an age , and town for example ) and you want 3 columns for each value
You can use this function :
SubField(text, delimiter[, field_no ])
SubField(My_Column, '/', 1) as Name,
SubField(My_Column, '/', 2) as Age,
SubField(My_Column, '/', 3) as Town,
Hope it helps