I assume that you want to transform the rows into columns. For this you could use the suggestion from Felip as a peparing step for a The Generic Load. Another way could be to identify each record and field with something like this:
load *, ceil(rowno() / 10) as RecordID, mod(rowno(), 10) + 1 as FieldID from ...
// 10 is the number of values in your example above
and using them to filter and join the data or using some interrecord-functions like Peek() or Previous() ? to build your needed records.