Say I have a sample table like this:
And I want to make it like this:
Basically, it is making values in column A unique by moving all duplicate values of each unique row into the next column over. The important thing is that I can retain the order of the columns in the order that they appear in the row. For example, for the unique value '3', I need the next value for '3' which is '67' to appear in column 'C' and not any other column, because it appears 2nd in the list of rows.
What is the easiest way to achieve this?