> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.datachamp.io/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Can I Merge Multiple Columns to One Column?


## ${color}[#1a63ba](Formating Data)

If you need to merge multiple columns into a single column, you can do so by adding a custom column and combining the desired columns. First, make sure to click on Browse and select the fields you want to merge. Then, create a custom column and use curly brackets to reference the other column. 
E.g. merge the Line items: Title and the SKU. 
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/merge-2-in-one-column_13y6wby.png)

If you want to combine two columns only under certain conditions—for example, combining "Address Line 1" and "Address Line 2" only when "Address Line 2" contains a value (i.e., is not empty)—you can use the [mapping function](/en/article/mappings-fhp4u7/)

First - click on "Browse" and select both fields. Second - use the mapping function:
![](https://storage.crisp.chat/users/helpdesk/website/-/d/0/0/f/d00f55635133d800/address-line_1ev8gx1.png)