PowerQuery: How can I concatenate grouped values?

by

You can use the GUI to do it this way:

  1. Select your LetterColumn and then Transform / GroupBy:
    enter image description here

  2. Select Add Column / Custom Column:
    enter image description here

  3. Click opposing arrows at top right of new Custom column to Extract Values from new Custom column:

enter image description here
enter image description here

  1. Remove AllData column.

More Related Contents:

  1. How can I reference a cell’s value in PowerQuery
  2. Convert matrix to 3-column table (‘reverse pivot’, ‘unpivot’, ‘flatten’, ‘normalize’)
  3. Excel UNIQUE Across Columns
  4. Excel: How to gather unique values in one column that are associated with duplicates in another column?
  5. Save excel file multiple times with file names in another workbook.
  6. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  7. Read/Parse text file line by line in VBA
  8. How do I find the last column with data?
  9. Excel VBA: Answer gets “stuck”
  10. filter out multiple criteria using excel vba
  11. Excel VBA autofilter all but three
  12. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  13. Generating CSV file for Excel, how to have a newline inside a value
  14. Excel VBA code to copy a specific string to clipboard
  15. Excel VBA – Range.Copy transpose paste
  16. How do you get a Range to return its Name?
  17. What charset does Microsoft Excel use when saving files?
  18. How can I run VBA code each time a cell gets its value changed by a formula?
  19. How to convert 32 bit VBA code into 64 bit VBA code
  20. Referencing Excel Userform Control Name Value From String (VBA)
  21. Refreshing all the pivot tables in my excel workbook with a macro
  22. Creating a chart in Excel that ignores #N/A or blank cells
  23. Countif With Multiple OR Criteria
  24. Vlookup to copy color of a cell
  25. every possible combination of the contents of 2 columns in excel
  26. How to delete rows in Excel based on criteria using VBA?
  27. Macro to export MS Word tables to Excel sheets
  28. VBA WinHTTP to download file from password proteced https website
  29. How to protect Excel workbook using VBA?
  30. Unique Rank value for a subgroup within a group

Leave a Comment