i have this long data set with all the values in one column and also in some cases the last value is missing
Data
Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
Panama 1991 40499 3054 21 300
Liberia 2005 42200 3100 22
Example last enrt is mssing in the following and speed could be in 1 decimal at times
Flag Year Built Deadweight Tons TEUs Speed Reefer TEUs
Liberia 2005 42200 3100 22.5
Can anyine help in separarting out this long set of data in to individual columns
Thanks
Bookmarks