Split single column into multiple columns

I have an excel sheet that is not formatted correctly. In column A, it has all the info into one column:

row (1) Cust # Cust Name Code Acc #
row (2) 1 Test 0001 5000
row (3) 2 Test2 0002 50001

I just need to seperate the column headers into different columns… Cust # to be in column A, cust Name column B, etc…

Read your excel file and use for each datarow with input as datatable obtained after read excel.
While processing first row split the value with space and create the headers in the new datatable with array obtained and for rest of the rows after splitting the value and add the array as datarow.