somnath_it2006
Well-known Member
- Joined
- Apr 11, 2009
- Messages
- 574
Hi All,
I have below input data in my Excel Sheet:
And I want my Output like this:
So what Excel function I can use in cell - E1 to achieve the output.
Appreciate all your help.
I have below input data in my Excel Sheet:
Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | A | Red | ||
2 | A | Blue | ||
3 | A | Yellow | ||
4 | B | Pink | ||
5 | B | Black | ||
Sheet1 |
And I want my Output like this:
Excel Workbook | ||||
---|---|---|---|---|
D | E | |||
1 | A | Red - Blue - Yellow | ||
2 | B | Pink - Black | ||
Sheet1 |
So what Excel function I can use in cell - E1 to achieve the output.
Appreciate all your help.