How to combine similar column cell and paste the corresponding data to another cell?
Hi Team,
I need a help with an excel issue that I have. I want to know how to combine similar cells in a columns and paste the corresponding column data separated by a coma to a separate cell in Excel. I have a sample file attached to this thread. Please help.
VBA solution looks best
Sub similaritems() lastrow = Worksheets("Sheet1").Cells(Rows.Count, "B").End(xlUp).Row k = 3 j = "" For i = 3 To lastrow + 1 Debug.Print i If Cells(i, 1) <> "" Or i = lastrow + 1 Then If j <> "" Then Cells(k, 7) = j l = Left(l, Len(l) - 1) Cells(k, 8) = l k = k + 1 End If j = Cells(i, 1) l = Cells(i, 2) & ", " Else l = l & Cells(i, 2) & "," End If Next i End Sub
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Hello Special-K,
I guess you had taken me wrong, I have given my equirement in the excel. In the excel I had given an example with Column A&B and the final out come should be Column G&H. I have to do this for around 1890 rows. Kindly help me in resolving this.
Thanks,
Rakesh.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks