• 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.