Concatenate values based on Cell Value

S

shails81

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 & Regard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Separation of text - concatenate excel 1
Validation of cell based on Drop down list 1
Please can you help me 7
conditionally format based on intersheet cell comparisons 1
3 results possible on every day. add up the number of each on each day. 2
Total columns Based on another cells value 4
SUM all Instances Q 15

Top