I won't say what you want is impossible, but it sure isn't practical. I suggest making a pivot table. (perhaps make the row fields be the concatenation and under that, the name field). To create a report with the structure you desire, you can use the information from the pivot to manually type the "Can't win" cells.
|