Hi All! I am seeking help and any advice on following challenge.
1. There are in total 65000 data entries in original file that need to be sorted and rearranged.
2. Column A has unique number for each row.
3. Column B has unique entry for multiple rows
4. Column C contains data that needs to be:
4.1. Checked for duplicates
4.2. Remove duplicates
4.3. Rearrange and move data in a new (specific) cell horizontally and with comma separated each value.
Example is in attached file.
Any comments and advise is highly appreciated.