Checking columns

I hope you are well!

I am trying to check two columns and find the first column contains the second column. Can you please help me with that?

Thanks,

Accepted answers

Guessing you are looking for something like below

Hope this helps : )

@atcodedog05
nice one,
Maybe I was thinking too much. hehe

Guessing you are looking for something like below

Hope this helps : )

Happy to help : ) @Simon1187

Cheers and have a nice day!

@Simon1187
Thank you for asking me .but this Fuzzy match is really not my thing.
I dont even like the word "Fuzzy" hehe.

Anyway, just give a blind shot.

@atcodedog05
nice one,
Maybe I was thinking too much. hehe

Hi Qie,

Thanks for the prompt reply. Could you please let me know how you transpose the data in one column? Did you use the Transpose tool?

Thanks,

@Simon1187
Yes, a Transpose tool will do.