View Single Post
  #1   Report Post  
shails81 shails81 is offline
Junior Member
 
Posts: 1
Default 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