How can I append 2 columns together?

mphi

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

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!