If you want to use an Sverweis but need multiple results, Power Query will help you!
Proceed as follows:
1. grouping
All rows (result: Table Object)
![](https://noprob.olbricht.it/wp-content/uploads/2023/09/1_gruppieren.png)
![](https://noprob.olbricht.it/wp-content/uploads/2023/09/2_table.png)
2. convert table object to list object
![](https://noprob.olbricht.it/wp-content/uploads/2023/09/3_table2.png)
3. extract values
Select separator for concatenating list values
![](https://noprob.olbricht.it/wp-content/uploads/2023/09/4_table3.png)
![](https://noprob.olbricht.it/wp-content/uploads/2023/09/5_table4.png)
Dieser Beitrag ist auch verfügbar auf:
Deutsch (German)