Split columns of text into additional columns

[M_SBS_6]

Hi, 

I have in my data a really long text output. Each output is linked to a survey response and the responses all end with a full stop and a semi colon. I need to be able to split the data to their own columns where this is true. 

Any idea how I do this please? 

Example line of text. 

testone.;test two.;test three.;test four.;

[DataNinja777 · Accepted solution]

Hi @M_SBS_6 ,

You can achieve you required output by utilizing Power Query's Split Column By Delimiter functionality as shown below:

I have attached an example pbix file.