How can I append 2 columns together?

mphi · 04/25/24

Hi! Just wondering how can I append 2 columns together? I have 4 columns: A, B, C, and D and each of the columns have 1, 2, 3, 4 values, respectively. What I would like to do is create 1 large column containing the values:

A1
B1
B2
C1
C2
C3
D1
D2
D3
D4

If this isn't possible, this is what I'm trying to do. I have a 2 column table of key-value pairs. I would like to prioritize those same key-value pairs into a single column based on certain criteria. What is the best way to do this?

bisaacs · 04/25/24

Hi @mphi,

The simplest way to append two columns together is by using the + sign:

=[Column A] + [Column B]

If you want there to be a space between the two, then you'd do this:

=[Column A] + " " + [Column B]

Hope this helps!

Andrée Starå · 04/25/24

https://community.smartsheet.com/discussion/121076/how-can-i-append-2-columns-together

Hi,

I hope you're well and safe!

Try something like this.

=JOIN(A@row:B@row, CHAR(10))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

mphi · 04/25/24

Hi and thanks for your responses!

Sorry, I didn't make myself clear enough. The JOIN concatenates the values together. I'm just looking to append 4 columns together.

Given:
A1 | B1 | C1 | D1
| B2 | C2 | D2
| | C3 | D3
| | | D4

I would like to make it

| A1 |
| B1 |
| B2|
| C1|
| C2|
| C3|
| D1|
| D2|
| D3|
| D4|

Does this make sense?

Andrée Starå · 04/25/24

https://community.smartsheet.com/discussion/comment/433123#Comment_433123

Happy to help!

Try this and build on it to get it the way you need.

="|" + JOIN(A@row:B@row, "|" + CHAR(10) + "|") + "|"

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

How can I append 2 columns together?

Answers

Help Article Resources

Categories