1. Home
  2. Knowledge Base
  3. Microsoft
  4. Excel
  5. Concatenate Sreference with multiple results

Concatenate Sreference with multiple results

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)

2. convert table object to list object

3. extract values

Select separator for concatenating list values

 

 

Dieser Beitrag ist auch verfügbar auf: Deutsch (German)

Was this article helpful?

Related Articles

Submit a Comment

Your email address will not be published. Required fields are marked *

Published on - 16. Sep 2023
Modified on - 27. Mar 2024
Views - 28
Likes - 0

Do you need help?

Kontaktiere uns gerne :-)
Contact Support
Skip to content