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