I have an error log coming through which i want to seperate each of the
errors into there own cell on the same row. and at the same time i want each
of the columns to only have the same error codes. example below of 2 rows of
errors

the errors are sperated by ; which i can then use text to columns but this
just seperates them out but does not sort them into be the same columns

example

row 1 orange; apples; pineapples; carrotts, lettuce
row 2 apples; carrotts; potatoes


to then be sorted into the following cells

row 1 orange apples pineapples carrotts lettuce
row 2 apples carrotts potatoes


sorry about the exmple and thanks for the help
pete