I am having trouble importing specific columns from a text file. As of now I can only import the first two columns. If I try to import a 3rd column farther down the list, it draws from the 3rd column from the text file instead of the column of my chosing. Here is a snipet of my raw data.

Pos.[°2Th.]  Height [cts]  FWHMLeft[°2Th.]  d-spacing [Å]  Rel. Int. [%]  Area[cps*°2Th.]  Area[cts*°2Th.]  Derivation  Backgr.[cts]  Height [cps]  K-A2 / K-A1 Ratio   Matched  Matched by        Shape Left  Significance    Source  Crystallite Size only [Å]  Micro Strain only [%]         h         k         l  Integral Breadth [°2Th.]  FWHMRight[°2Th.]  Peak Number     h k l

    25.6038     3688(198)           0.0575        3.47638          50.16            26.04           358.56    Pure KA1        642.36        267.84                           No  96-900-8095;00..       0.883        0.0000  Rietve..                3988.873000               0.043576         0         1         2                  0.097222                              1     0 1 2 

    35.1767     7352(340)           0.0599        2.54917         100.00           107.50          1480.31    Pure KA1        439.86        533.91                           No  96-900-8095;00..       0.826        0.0000  Rietve..                 731.903900               0.174147         1         0         4                  0.201350                              3     1 0 4 

    37.8035     3557(132)           0.0607        2.37786          48.39             7.99           110.03    Pure KA1        364.76        258.33                           No  96-900-8095;00..       0.810        0.0000  Rietve..               29501.050000               0.004030         1         1         0                  0.030932                              5     1 1 0 

    41.7029       34(115)           0.0619        2.16409           0.47             5.04            69.40    Pure KA1        311.27          2.50                           No  96-900-8095;00..       0.786        0.0000  Rietve..                  48.944610               2.210751         0         0         6                  2.013277                              7     0 0 6 

    43.3798     5538(218)           0.0624        2.08424          75.33            38.87           535.28    Pure KA1        309.04        402.19                           No  96-900-8095;00..       0.776        0.0000  Rietve..                4676.969000               0.022282         1         1         3                  0.096653                              9     1 1 3 

    46.2042        54(87)           0.0633        1.96319           0.73             0.93            12.84    Pure KA1        245.57          3.91                           No  96-900-8095;00..       0.759        0.0000  Rietve..                 587.495400               0.167081         2         0         2                  0.238608                             11     2 0 2 

I want to be able to take the first 2 columns 'Pos.[°2Th.]' and 'Height [cts]' , as well as the last three columns 'h', 'k' and 'l'. The last three columns 'h', 'k' and 'l' need to be merged into one data set so it is not treated indivudally.

Here is a simple breakdown of what I have so far:

Looking forward to the responses.

--jlalb

PS. I know it is possible from a text file, but would it be much easier from an excel file as the raw data source?