Tammu
asked on
MS Excel 2007 loop thru based on sku no and display size and color in the next columns
My current excel 2007 sheet has data like below. I have attached a sample file
Sku Color Size
1001 Black S
1001 Black L
1001 Red S
1001 Red XL
1002 Black XXL
1002 Yellow XS
1003D Tan XL
1003D Tan XXL
I am trying to display them as follows
Sku Color Size
1001 Black,Red S-L-XL
1002 Black,Yellow XS-XXL
is this possible to do this using Excel.
Thanks and appreciate it
test-sample.xlsx
Sku Color Size
1001 Black S
1001 Black L
1001 Red S
1001 Red XL
1002 Black XXL
1002 Yellow XS
1003D Tan XL
1003D Tan XXL
I am trying to display them as follows
Sku Color Size
1001 Black,Red S-L-XL
1002 Black,Yellow XS-XXL
is this possible to do this using Excel.
Thanks and appreciate it
test-sample.xlsx
ASKER
Sorry about that and thanks for quick reply, I have attached a new and corrected sample.
Thanks
test-sample.xlsx
Thanks
test-sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Brilliant. Thanks
You need to either post a new sample file that is consistent, or you need to tell us how to handle those rows (and whether there are any other anomalies, too).