Sort list based on all columns

[Jacc]

I have a list of multiple columns.
I want to sort the list based on all columns.
Only strings that are equal can be on the same row is one way of describing it.
Quite easy concept really, there is a before and after table in the attachment.

[jindon]

For the data provided

Please Login or Register  to view this content.

[Jacc]

Wow! It works perfectly on the sample data! Very impressive!

I forgot to include, sometimes the data is very compact, almost no empty cells. With compact data the macro needs to add rows to the table as needed.

Also sometimes there are too many rows in the table ("fluffy data"), then the macro needs to remove rows as needed.

Can you make it work on this too?

[jindon]

Do you mean?

Please Login or Register  to view this content.

[Jacc]

Yes, this works excellent for the compact data!

However with Fluffy data it needs to remove empty rows that exist from beginning and also empty rows that are created when sorting.
I assume this will be an easy task for you also?

This will be final request.

[jindon]

This time I need to see your desired result.

[Jacc]

Ok, here is sample data Before and After.

[jindon]

This is different from one before.

Latest, columns have unique within one column, but duplicates in one before...

[Jacc]

Ok, my mistake. My data does not contain duplicates within a column.

[jindon]

Then just change one line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Jacc]

Ok this looks more like black magic than VBA to me.
But I implemented it and it works perfectly well!
Thank you so much for all your assistance!

[jindon]

You are welcome and thanks for the rep.