Sunday, May 13, 2012

yogi_Filter On Unique Column A While Concatenating First Unique Row Of Each Group With Variable Data In B

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #537    May 13, 2012     www.energyefficientbuild.com.

user digitaltoast said:
Filtering on unique column A while concatenating first unique row of each group with variable data in B.
Possibly the worst question title in history, but here's a bit more:
Column B contains product names which are identical except for a size name at the end. Column A contains a product code which is identical for all sizes of each product.
I want to go from:
A         B
123      Socks large
123      Socks small
234      Pants large
345      Shirt medium
345      Shirt large
etc
To
A          B
123       Sock Large, small
234       Pants large
345      Shirt medium, large
I've had a fair old bash at it and have shown all my working and what I've tried and failed at so far, at:
Any help would be appreciated.
-------------------------------------------------------------------------------------------------
following is a solution to the problem