excelexcel-formulaexcel-365# Merge cells of text using filter and dynamic array

In the same way of my question about the double value Remove double values and sum the values, I need to concatenate textual value in function a filter value, let see the table :

And I want this table :

I'm using dynamic array, and I want that the output formula are also dynamic array.

Now, the only formula that I can get is this one:

[fr]

```
=JOINDRE.TEXTE("/";VRAI;CHOISIRCOLS(FILTRE(B1#;PRENDRE(B1#;;1)=H1);2))
```

[en]

```
=TEXTJOIN("/", TRUE, CHOOSECOLS( FILTER( B1#, TAKE( B1#,,1) = H1),2))
```

But, I want to replace H1 by H1# but it doesn't work.

What is the best way to get it ? Thank's

Solution

You need to use the following formula :

• Formula used in cell `E2`

```
=LET(
a, B2:B11,
b, C2:C11,
ua, UNIQUE(a),
HSTACK(SEQUENCE(ROWS(ua)),ua, BYROW(ua, LAMBDA(x, TEXTJOIN("/",,FILTER(b,a=x))))))
```

Or, with `GROUPBY()`

applicable to `MS365`

Beta Channel Version for now:

```
=LET(
a, GROUPBY(B1:B11,C1:C11,ARRAYTOTEXT,,0),
HSTACK(SEQUENCE(ROWS(a)),a))
```

- Build vertical summary from Columns with Count
- Excel - Create a Unit Conversion sheet - Multiple links
- update cell when column header matches a list
- Delete text in cell subject to Worksheet_Change
- Counting the number of visible rows after autofilter
- Excel 2007: AVERAGEIF, SUMIF, COUNTIF, MAXIF, MINIF across multiple sheets, multple rows
- Import CSV data from a txt file skipping the first line and adding headers
- Simplifying SumIFs formulas for efficient excel formula
- I'd like to find out how to find the current streak of non-negative numbers in a row of data in Excel
- ValueError: Invalid character found in sheet title
- decrypt excel files
- Excel table search funcion that looks for partial string match
- Combine macros to filter on today's and tomorrow's date
- Converting line breaks to commas in excel sheet using Powershell
- Combinations of numbers arranged side by side as many as a random number (VBA)
- How can I remove ONLY leading and trailing spaces while leaving spaces in between words alone with an excel formula?
- VBA Date as integer
- Sliding Window Auto Increment Range
- Count cells with different conditional ranges
- Turning flattened pivots data into tables -Error tables can't overlap - Excel Vba
- How do I get only a specific part of a cell in Excel or Numbers?
- Calculate the Legendre symbol of two integers in Excel
- Unable to get text wrapping or vertical centering to work with xlsxwriter
- Number stored as text warning in excel using POI
- VBA Excel paste to the columns in regular intervals
- Convert filtered values from formulas to values
- Sorting Dictionary by nested class objects data [VBA]
- Events does not appear when making an Outlook query from Excel
- The script works well when I use MSXML2.XMLHTTP.6.0, but it fails miserably when I switch to MSXML2.serverXMLHTTP.6.0
- How to convert text string (d h m s) to time format in excel