The above shows a table of mirrored data. You have apple, orange, pear and banana headers going both horizontally and vertically. A 'o' symbolises that you prefer that fruit compared to whatever it's being compared to, looking at the data from left to right. For example, the 'o' in cell D3 shows that you prefer apples to oranges. If D3 is an 'o', then C4 has to be a 'x', because you are comparing oranges to apples instead on that cell, and we already know we prefer apples to oranges.
The values in column H are what I would like to generate, but am doing manually currently. It plucks out, from the row, the fruits that were preferred to whatever fruit we are comparing to. For example, row 4 is us comparing oranges to other fruits. We prefer apples and pears to oranges, so cell H4 writes 'Apple, pear'. In row 3, we preferred apples to all other fruit, so there is no value there.
Is it possible to automate what I have in column H? I am using excel 2013 and do not have access to textjoin.
Thank you.
