Checking columns

[Simon1187]

Hi @Qiu 

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,

[atcodedog05 · Accepted solution]

Hi @Simon1187 

Guessing you are looking for something like below

or

Hope this helps : )

[atcodedog05]

Happy to help : ) @Simon1187 

Cheers and have a nice day!

[Qiu]

@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.

[Qiu · Accepted solution]

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

[Simon1187]

@Qiu 

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, 

[Qiu]

@Simon1187 
Yes, a Transpose tool will do.