Join Selected Values Vertically with a Line Break Separator

ASAP Utilities › Rows & Columns  ›  7. Join Selected Values Vertically with a Line Break Separator

This tool merges data from the rows in your selection by joining adjacent cell values vertically, separating them with a line break, into the top cell of each column.
In doing so, the data from the lower rows is removed and consolidated into the top cell of each column.

This tool is a quick alternative to Excel's CONCATENATE(), CONCAT(), or TEXTJOIN() functions.

Tip:
Try our =ASAPMERGECELLS() function for even more flexibility in combining values.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: Merge row data, separate cells by a line break (Here's the English version.)
Merge row data, separate cells by a line break

Additional search terms to help you find this tool:
Merge row data with line breaks, Join row cells with line break separator, Combine row cells with Alt+Enter, Excel merge cells with line breaks, Consolidate row data with line breaks, Join cell contents with a line break, Merge cell contents using CHAR(10), Excel text join with line breaks, Combine multiple cells with line breaks

Get Started with ASAP Utilities 9

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial