Table 1
| Employee | Country |
|---|---|
| John | USA |
| Davis | Australia |
| Maria | Australia |
| Nancy | USA |
Table 2
| Country | Employee | Clients |
|---|---|---|
| USA | ?? | Johnson |
| IBM | ||
| RedHat | ||
| Phizer |
?? should correspond to data from Table 1 with the Country filter.
For our example, it would be John, Nancy in the same cell, preferably in the next line (alt enter)
John,
Nancy
I have tried to concatenate transpose, but I am unable to make it work.
Moreover, I am unable to find any way to do the equivalent of sumif() in transpose.
CodePudding user response：
In Excel use Pivot Tables:
