Excel 2007 : Combine Text From Multiple Cells Into New Cell Based On Criteria

Hello,
Can you please kindly help me to solve my problem.
I have excel sheet with 3 columns with data
A B C
--- --- ----
A1 NRTI K70R
A1 NRTI M184V
A1 PR L19M
A1 PR M36IM
A2 RT Q85HQ
A2 RT D177E
A2 PI N88D
A2 PI A71AV

I want result should look like this

A B C
--- ---- ---
A1 NRTI K70R, M184V
A1 PR L19M, M36IM
A2 RT Q85HQ, D177E
A2 PI N88D, A71AV

Thanks in advance
Annu

Originally Posted by pike

hi ANNU
Welcome to the forum

Try .. this macro

Please Login or Register  to view this content.

Hi Pike,

Thanks for the solution.
After using your Macro, Column A data is not apearing as i want it to be.
original data---
A B C
= = =
1 A AB
1 A BC
2 C FD
2 C RE

after applying your macro I am getting like this
after macro
A B C
= = =
1 A AB,BC
1 C FD,RE

But I want result should be like this

A B C
= = =
1 A AB,BC
2 C FD,RE

Thanks Again,
Annu