Copy_Duplicates_Remark Values

[Nipendra.dhiman]

Hi All,

Here in the attached data I have some duplicates IDs , I want to copy all the remarks if available and paste in-front of the single unique Id.

Lets take a visible example:-

If I have ID (101) four time in the data:-

ID Remarks

101 A

101 B

101 A

101 C

Output should Like this:-

ID Remarks

101 A B A C



Please share your experience and suggestions.



Thanks you

Nipendra

 

[jayalaxmi]

Hi All,

Here in the attached data I have some duplicates IDs , I want to copy all the remarks if available and paste in-front of the single unique Id.

Lets take a visible example:-

If I have ID (101) four time in the data:-

ID Remarks

101 A

101 B

101 A

101 C

Output should Like this:-

ID Remarks

101 A B A C



Please share your experience and suggestions.



Thanks you

Nipendra

see this is the thing u needed

 

[jayalaxmi]

hey sorry I think It will work with VBA code..

 

[Nipendra.dhiman]

Thank you Jaya i was an awesome one by using formula but this time i am trying to do by vba only.

Appreciated Your Quick response.

 

[jayalaxmi]

Thank you Jaya i was an awesome one by using formula but this time i am trying to do by vba only.

Appreciated Your Quick response.

hey as I don't know VBA I cant help

I had got something u can go thru this if u want

Thanks for appreciation

 

[jayalaxmi]

http://www.get-digital-help.com/201...n-multiple-values-concatenated-into-one-cell/

 

[Deepak]

Hi,

Check this..

 

[Deepak]

Hi,

Check this..

If it worked then just changed the below lines!!

Cells(start_row, 6) = Trim(Replace(Mid(c, 2), Chr(10), ""))
c = ""
start_row = start_row + 1

 

[Nipendra.dhiman]

It works perfect really appreciated

Thanks a lot.

i wish, one day i will be able to do the same.

Nipendra

 

[Deepak]

It works perfect really appreciated

Thanks a lot.

i wish, one day i will be able to do the same.

Nipendra

Glad that worked!!