The ASAP Utilities menu in Excel (English)
Join Selected Values Vertically with a Delimiter...
ASAP Utilities › Columns & Rows › 6. Join Selected Values Vertically with a Delimiter...This tool merges data from the rows in your selection by joining adjacent cell values vertically 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 reach column.
You can customize the process by specifying a delimiter to insert between the cell values. 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.
Screenshots
Example screenshot: Combine the data from the rows in your selection
Practical tricks on how this can help you
Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!Starting this tool
- Click ASAP Utilities › Columns & Rows › 6. Join Selected Values Vertically with a Delimiter...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
Join cell values vertically, Combine rows into one cell, Merge cells from rows, Consolidate row data, Vertical merge cells tool, Combine cell contents from rows, Excel merge rows utility, Concatenate cells vertically, Join row cell values into top cell
Join cell values vertically, Combine rows into one cell, Merge cells from rows, Consolidate row data, Vertical merge cells tool, Combine cell contents from rows, Excel merge rows utility, Concatenate cells vertically, Join row cell values into top cell
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Join Selected Values Horizontally with a Delimiter... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.