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 |
Solved! Go to 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.
Thank you so much for your help. I really appreciate that 🙂