I have messy data in which different columns are all entered in the first column on Excel. I want to split the text to different columns, but am struggling with using the 'text to columns' function on Excel, as my columns are separated by multiple spaces (and the number of spaces is not always constant). Is there any way that excel can split the data into different columns based on a 'pattern'? This is how I want the data to look, ultimately.
Here is a link to my data.
Any tips welcome - thanks so much!
P.
@
for example for shown sample data); 3) Use Split data to columns - By separator, using char from (2) as separator.