# Merging Columns Into One Cell With Line Breaks

**URL:** <https://community.omni.co/t/merging-columns-into-one-cell-with-line-breaks/438>\
**Category:** Visualizations\
**Tags:** calcs, ai\
**Created:** [January 20, 2026, 10:55pm UTC](https://community.omni.co/t/merging-columns-into-one-cell-with-line-breaks/438 "2026-01-20T22:55:49Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![keegancianfrone](https://avatars.discourse-cdn.com/v4/letter/k/c2a13f/32.png) [@keegancianfrone](https://community.omni.co/u/keegancianfrone)\
**Post date:** [January 20, 2026, 10:55pm UTC](https://community.omni.co/t/merging-columns-into-one-cell-with-line-breaks/438/1 "2026-01-20T22:55:49Z")

</div>

**Overview**

Sometimes you need to pull information from multiple columns and display it neatly in a single cell. A example is combining a **Full Name** , **Email** , and **State** into one cell, with each value appearing on its own line.

This article walks through a simple, repeatable way to do that using Omni’s natural language formula feature within the `Results` tab of a query. Here are the the sample fields we will use for this exercise:

 ![Screenshot 2026-01-20 at 2.12.23 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/21f1599bc89bb6303061186b316c3d3ffdd8717a.png)

**Step 1:**  **Use Omni’s Natural Language Formula**

In a new column (for example, Column D), you can use Excel’s natural language prompt or manually enter the formula.

You can ask something along the lines of:

_“In a new column, combine columns A, B, and C into a single cell separated by a line break.”_

The formula will look something like: `=CONCAT(A1, CHAR(10), B1, CHAR(10), C1)`

–\> `CHAR(10)` tells Omni to insert a line break. The `CHAR()` function returns character based on its numeric code, where `10` represents line feed.

**Step 2: Wrap Text**

Select your concatenated column (i.e. column D) and click on the `word wrap` icon on the editor bar.

 ![image](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/b9a250d56e72749eed94f4ab625c677dad64d9c5.png)

Your table should look something like this:

 ![Screenshot 2026-01-20 at 2.06.06 PM](https://canada1.discourse-cdn.com/flex004/uploads/omni/original/1X/b580e9c003130a1558deccb608cd105f863bf42f.png)