Forum Discussion
Separating data with multiple variables in one cell into multiple
Hi Anonymous ,
Not really sure if I understand your data in the format you present it but is this a single column per row or do you have 3 columns?
Another question is how do you know what is the split between the several actions and topics? Is it based on the space between the words or are there any other way to limit those fields?
In the Query Editor you can do a split by delimiter, and instead of doing new columns you can do rows, believe that is what you need to do however if you can answer the questions above it woudl be easier to help you achieve the final result.
Super UserHi Anonymous ,
Not really sure if I understand your data in the format you present it but is this a single column per row or do you have 3 columns?
Another question is how do you know what is the split between the several actions and topics? Is it based on the space between the words or are there any other way to limit those fields?
In the Query Editor you can do a split by delimiter, and instead of doing new columns you can do rows, believe that is what you need to do however if you can answer the questions above it woudl be easier to help you achieve the final result.