How about reading in each column via READEXCEL?
You have to be aware that the so called "tables" in Prime are meant for manual input of data only, not for display of already existing data.
A Prime table actually just creates a collection of individual vectors.
In your Prime sheet you actually had defined 17 individual vectors.
Here as an example the creation of three of these 17 vectors using the data in the Excel sheet:
When we compare the vectors created that way with the ones you had manually input we see some discrepancies - in some places you did not use the exact Excel data in your manual input:
Guess it would also be possible to read in the whole sheet including the data you are not interested in an then use the thus created Prime matrix to extract the data needed.
Maybe something like
Prime 10 sheet attached
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
