Say I have a sample table like this:

enter image description here

And I want to make it like this:

enter image description here

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?


This video may help you. You need Microsoft's Power Query add-in which also comes as a built-in feature with Excel 2016 and 365. For basics of Power Query please refer here.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.