Hi! I got the table to work as it should. Now I am trying to rearrange the output data for each unique SKU horizontally in one cell.
Like with Concatenate function but I am not sure how to make conditional concatenate function.
Attached is file with desired output.
Thanks!
Hi Alan, thanks for the info! Appreciate your help.
Hi alansidman, thank you for taking the time to respond!
The code works perfectly but it loops thru just those 10 sample entries. I have 65000 entries that need to be sorted. Was trying to figure it out but so far haven't learned how to do that.
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.
Thanks,
Aivars
