Matching two files

[tani1989]

Hi, I have one excel file and wants to generate the output file given below from it. The output file already have the value as columns, i only need some help regarding how to display yes and no based on matching the files.

File 1

Name	value
Abhi	2
Tani	3
kim	2

Output:

Name	2	3
Abhi	Yes	No
Tani	No	Yes
Kim	Yes	No

[AbhilashR · Accepted solution]

@tani1989 - You need to transpose your data and use a multi-field formula to populate the table. Attached is an implementation of this solution. Please mark this post as solution accepted if it answers your question.

[tani1989]

Thank you so much for your help. I really appreciate that 🙂