i have n number of rows in a 1st sheet with different customers with duplicates items and there is total and pending quantity of that items. So i want a customer with unique items with comma separate values along with total and pending quantity in some other sheet. Can anyone please me out with this.
test.jpg
Bookmarks