Search code examples
google-sheetsconcatenationarray-formulasgoogle-sheets-formulatextjoin

How to merge multiple column into 1 cell with linebreak/new line in Google Sheets?

enter image description here

Hi, I want to ask is it possible to merge more than 1 cell result into one cell, like the result shown in B10 with formula?

Solution

  • you can do it easily like this:

    =ARRAYFORMULA(TEXTJOIN(CHAR(10), 1, H16:H25))

    0