I have a huge excel list (20k+ rows) and want to split that one column list into multiple columns. Previously I used the Data|Text-to-Columns Wizard but it appears to have a limitation: I cannot specify after how many "splits" to stop to split. Example data:
type: abds : das files: asdfs:jgkd
|type|abds : das| |files|asdfs:jgkd|
thanks for your time :)!