This is my file (fixed lengths):
item 1 tire
color black
price 50
item 2 car jack
color blue
price 35
item 3 screwdriver
color red
price 3
My idea was to import it to a (temp) table first and copy the position number (which is on position 20 in the item line) to a new column. Then fill up the position numbers to indicate which property (color, price) belongs to pos 1,2,3. Maybe there is an easier way to import the data.