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:
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
No comments:
Post a Comment