Extract Difference Character

[bubblyjai1982]

Hi All

Need your assistance !!

I have two sets of data before and after which has few changes when compare both data

Need to extract the character / data which is different from before data.

For your reference data attached.

Kindly assist.

Many Thanks.

[aatalai]

@bubblyjai1982 this is not 100% what you asked for but could be a good starting point, tolkensie the data both before and after then join on postion and see where the differences, let me know how you get on

[aatalai]

@bubblyjai1982 this is not 100% what you asked for but could be a good starting point, tokenize the data both before and after then join on position and see where the differences, let me know how you get on

[bubblyjai1982]

Hi Aurora

Thanks for the response but I'm looking something like below

Before

A

B

C

D

E

F

G

H

After

A

B

C

D

E

F

G

H

I

J

Difference

I

J

It should give the difference in one cell only.

Thanks

[aatalai · Accepted solution]

@bubblyjai1982 ok add a summarize at the end and concatenate