Find similiar cells in rows, and move them togehter

[banaanas]

Hi!

I am trying to create a macro that would compare certain columns in range. In those columns there are "keys", and even if the column is different the same key always means the same thing.
I would like to move all similar keys to the same column, starting with the most common one and moving to the least common. The data can only be moved inside the original row, but column dosn't matter. Kind of like so:
¨
EXCEL_2018-09-14_06-50-58.png

Also, the key values are connected to the "trash", so when I move the key I need to move the whole range of cells inside the row to the next key.
I don't have any code yet, I was thinking that this should probably be done with loading all cell values from key-columns to an array with the cell value and location stored, but that is as far that I have come up with it.

Does anyone have any ideas on how to accomplish this?

[kersplash]

Attach a sample workbook, showing your expected result mocked-up.

Go Advanced -> Manage Attachments -> Upload

[banaanas]

Ok, here! Hope it helps.

[kersplash]

But in your output you have Key4 and Key8 in the same column?

Maybe some more "real-world" desensitised sample source data might make sense.

[banaanas]

But in your output you have Key4 and Key8 in the same column?

Maybe some more "real-world" desensitised sample source data might make sense.

Yes, because there is only 1 of them and the data need to be filled from left to right.
So basically the macro should try to group up as many key values as it can, but the rest will be filled where it can.
I will start now to compile a real-world example with real data, hopefully, it will help

[banaanas]

The more I think about this, the more problems I see. I think this is not worth the effort. Sorry for wasting your time.