Split one row to many like Excel Parse Data

Help Studio
1

Data
sourceTD: >>only one column , space between value
column1
ID Name Department Position Phone
resultTD: >>5 rows
column1 column2 column3 column4 column5
ID Name Department Position Phone

My code is:
Assign resultTD=dsourceTD.Clone

Add Data Row(use Activity* 4 times for add 4 rows)
ArrarRow:
DataRow: sourceTD.NewRow
DataTable: resultTD

Assign resultTD=
(From row In sourceTD.AsEnumerable()
Select resultTD.LoadDataRow(New Object(){
row(0).ToString.Split(" “c)(0).Trim,
row(0).ToString.Split(” “c)(1).Trim,
row(0).ToString.Split(” “c)(2).Trim,
row(0).ToString.Split(” “c)(3).Trim,
row(0).ToString.Split(” "c)(4).Trim
},False)).CopyToDataTable

Questions
Q1: error: Input Array is longer than the number of columns in the table ?
Q2: IF column1 is more value (unsure how much), how to write code?

2

@scorpialee

The given array is longer…you can use sourcetd might be having less columns …can you check the same

Cheers