Forum Discussion
Combining Text Cells
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 d...
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.
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)
)