Function Problems

How to Combine Multiple Excel Tasks into One Cell with Line Breaks

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to merge multiple rows of task descriptions belonging to specific job codes into a single cell, separated by bullet points and line breaks, while keeping the job information intact.

Product: Excel
Device & OS: not provided
Scenario: Consolidating occupational workbooks where tasks are listed in separate rows but need to be grouped by job code into a single, highly readable cell.
Observed behavior: The data is spread across multiple rows for each job code, and the goal is to format it into a single cell with distinct bulleted lines.

Before you start

Ensure that your dataset has clear identifier columns (like job codes) and that you have enabled 'Wrap Text' in your target cells to display line breaks properly.

Solution 1Recommended

Use TEXTJOIN and FILTER Functions (Recommended)

This method uses dynamic array formulas to efficiently group tasks by a specific job code and combine them with line breaks and bullet points.

By combining the TEXTJOIN, FILTER, UNIQUE, and XLOOKUP (or INDEX/MATCH) functions, you can dynamically pull and format all tasks associated with a single job code into one cell.

Extract Unique Job Codes

Select an empty column (e.g., Column E) and create a list of unique job codes using the formula: =UNIQUE(Sheet1!A2:A2000).

Retrieve Job Titles

In the next column, fetch the corresponding job title using XLOOKUP: =XLOOKUP(E2, Sheet1!A:A, Sheet1!B:B) or INDEX/MATCH: =INDEX(Sheet1!B:B, MATCH(E2, Sheet1!A:A, 0)).

Combine Tasks with TEXTJOIN

In the third column, combine the tasks by typing the formula: =TEXTJOIN(CHAR(10), TRUE, "• "&FILTER(Sheet1!C:C, Sheet1!A:A=E2)). CHAR(10) acts as the line break, and "• " adds the bullet point.

Enable Wrap Text

Select the cell containing the combined tasks, navigate to the 'Home' tab on the ribbon, and click the 'Wrap Text' button to make the line breaks visible.

Wrap Text Requirement: The CHAR(10) function inserts a line break character, but Excel will not display multiple lines in a single cell unless 'Wrap Text' is actively enabled for that cell.

Solution 2

Use Python in Excel for Large Workbooks

For exceptionally large or complex workbooks, utilizing Python's data manipulation capabilities via DataFrames can group and join text efficiently.

WPS Spreadsheet Solution

Combine Cells and Manage Data Seamlessly with WPS Office

WPS Spreadsheet fully supports dynamic array functions like UNIQUE, FILTER, and TEXTJOIN, making it incredibly easy to merge multiple rows into a single cell with line breaks.

1. Open Your Workbook: Launch WPS Spreadsheet and open the workbook containing your occupational data.
2. Apply Unique Identifiers: Use the =UNIQUE() formula in a new column to list your job codes without duplicates.
3. Merge Data with Formulas: Enter the =TEXTJOIN(CHAR(10),TRUE,"• "&FILTER(...)) formula to combine your task rows into one cell.
4. Format the Cell: Select the target cell, go to the 'Home' tab, and click 'Wrap Text' to display the stacked bullet points correctly.

Fully compatible with Microsoft Excel formulas and .xlsx formatsSupports TEXTJOIN, UNIQUE, and FILTER for advanced data processingLightweight and runs smoothly on all major operating systemsFree to use for everyday data management and reporting

microsoft office alternative - wps office

Frequently Asked Questions

Why are my merged tasks showing on one single line instead of multiple lines?

You need to enable 'Wrap Text' for the formatting to display correctly. Select the cell with your formula, navigate to the 'Home' tab on the top ribbon, and click 'Wrap Text'. The CHAR(10) character requires this setting to visually break the lines.

What does CHAR(10) do in an Excel formula?

CHAR(10) generates a line break character in Excel (equivalent to pressing Alt+Enter). When used within text manipulation functions like TEXTJOIN or CONCATENATE, it forces the subsequent text to start on a new line within the same cell.

Can I use older Excel versions to combine rows like this?

The TEXTJOIN, FILTER, and UNIQUE functions are available in newer versions (Excel 2019, Office 365, and WPS Office). If you are using an older version, you may need to use VBA (Visual Basic for Applications) or a series of complex IF and CONCATENATE formulas to achieve a similar result.

Excel & Data Problems