Combine unique data from a cell on another sheet with another cell on the current sheet without loosing its current data

[ameenuksg]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC.[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 2[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]



I have 2 sheets which are duplicates in data. Sheet 1 is the master sheet and the Sheet 2 is for someone to add any additional comments. Just say I have updated with more comments in the remarks column in Sheet 1 as such:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ.[/TD]
[/TR]
</tbody>[/TABLE]

My colleague had already updated with comments on Sheet 2 with his own input on the initial text. Now how do I combine his updated text and my updated text without duplicating data. The result I want would be something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]

Would not want to see a result anything like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ. ABC. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]

I hope the above explains what I am trying to day. I would greatly appreciate any help and thank you in advance.

 

[ameenuksg]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC.[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 2[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]



I have 2 sheets which are duplicates in data. Sheet 1 is the master sheet and the Sheet 2 is for someone to add any additional comments. Just say I have updated with more comments in the remarks column in Sheet 1 as such:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ.[/TD]
[/TR]
</tbody>[/TABLE]

My colleague had already updated with comments on Sheet 2 with his own input on the initial text. Now how do I combine his updated text and my updated text without duplicating data. The result I want would be something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]

Would not want to see a result anything like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Sheet 1[/TD]
[TD]Remarks[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC. XYZ. ABC. EFG. HIJ[/TD]
[/TR]
</tbody>[/TABLE]

I hope the above explains what I am trying to day. I would greatly appreciate any help and thank you in advance.

Hi All Let me try to explain again here:

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Remarks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John had his lunch.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John went home.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 1

[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Remarks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John had his lunch. He did his homework too.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John went to play Basketball.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2

Now how do I merge above cell A2's data of Sheet 1 with Sheet 2 without duplicating data. I would like to get the following result in Sheet 1 Column B:


[TABLE="class: grid, width: 50"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Remarks[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]John had his lunch.[/TD]
[TD]John had his lunch. He did his homework too.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]John went home.[/TD]
[TD]John went home. John went to play Basketball.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Sheet 1 Updated after merging data