Appending, sorting and removing duplicates of chunks of data per column

Hi Guys,

I have two worksheets:

Sheet1 which has one column ColA, that contains unfixed number of chunks of data all separated with one empty row.
Sheet2 which has one column ColA that contains fixed number of data at 32 each, and also all separated with one empty row.

What I am after is to:

1. append each group of data from Sheet1 ColA, with its equivalent group of data in Sheet2 ColA, so that the first group of data in Sheet1 ColA goes with the first group of data in Sheet2 ColA, and so on, then
2. sort ascend each group, and remove duplicates if there's any.

If a group in Sheet2 does not have an equivalent group in Sheet1, then it is sorted and had any duplicates removed as there's nothing to append from Sheet1.

The final outcome is expected to be in Sheet3 ColA, as shown in the attached example.

Can I get assistance with this question, please?

Many thanks in advance.

List_of_names_appending_sorting.xlsx

Hi there,

If all of the names are to be combined as shown in Sheet 3, can what you want be achieved by just combining all of the names from Sheets 1 and 2 into a single list, sorting them, and then removing any duplicates?

Regards,

Greg M

This should do

Please Login or Register  to view this content.

Thank you very much Jindon for such masterpiece. Words are incapable to express my gratitude.
I ran the code it did exactly what is needed.
All the best my dear.

Thank you very much Greg M for your response. In fact, the reason behind segmenting data into groups it that every group has its individual properties. In my real data, they are not names, but components of different entities.
All the best.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Thank you very much Kaper for your magic code. I also tested it and it did run smoothly and produced the desired result.
Now I have two masterpieces in hand for the same question.
Once again thank you.
Best regards,