Concatenate values based on Cell Value
Hello All,
I need to concatenate values based on a cell value. For Eg.
Scenario:
Col. A - Col. B
Sales - 12
Sales - 45
Purchase - 26
Logistics - 4
Logistics - 20
Logistics - 30
Output I need as follows:
Col. A - Col. B
Sales - 12,45
Purchase - 26
Logistics - 4,20,30
Kindly help.
Thanks & Regards
|