Combining Text Cells

[not_ashuma]

Hello,

I have a spread sheet that has text in different cells. The cells are sorted by day of the week. I would like to combine all of the text cells into one cell on another sheet based on the day of the week. Similar to the SUMIF function for summing up numbers for a category. I can't seem to find a formula that does that.

I would like a formula that puts all the descriptions for Tuesday into one cell on another sheet. Repeat the process for the different days of the week. By date is fine too.

[#2]

@not_ashuma 

You can use TEXTJOIN and FILTER:

=TEXTJOIN(" ". TRUE, FILTER(description_range, day_range="Tuesday", ""))

[#3]

@not_ashuma 

Here's my approach:

=LET(
    filtered, FILTER(Table1[Description:], Table1[Day:] = B2, ""),
    linebreak, CHAR(10),
    TEXTJOIN(linebreak, , filtered)
)

[#4]

Can you do your solution without a table? My data isnt in a table currently. When I put it into a table it messes up the format pretty badly.

@Patrick2788 

[#5]

@not_ashuma 

Yes, here's a version with no table that uses dynamic named items. The formula is a bit shorter:

=LET(
    filtered, FILTER(description, day = B2, ""),
    linebreak, CHAR(10),
    TEXTJOIN(linebreak, , filtered)
)

[#6]

What am I doing wrong here?

@Patrick2788 

[#7]

@not_ashuma 

Does your copy of the workbook have these dynamic named items?