# Combine text from two columns

**URL:** <https://community.glideapps.com/t/combine-text-from-two-columns/37197>\
**Category:** Ask for Help\
**Created:** [January 14, 2022, 7:28pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197 "2022-01-14T19:28:14Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [January 14, 2022, 7:28pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/1 "2022-01-14T19:28:14Z")

</div>

Hi Everyone,

Does anyone know of a way that I can combine text from two columns beside each other into one new column. For example:

Column A. Column B Output  
A1 A A1A  
A1 B A1B  
A1 C A1C  
A1 D A1D  
A1 E A1E  
A1 F A1F

I tried a template but since Column A has the same values it cannot combine the columns. If anyone has any ideas please let me know?

Cheers

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [January 14, 2022, 7:29pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/2 "2022-01-14T19:29:44Z")

</div>

My chart got messed up after posting

Column A - A1, A1, A1, A1, A1  
Column B - A, B, C, D, E, F  
Output - A1A, A1B, A1C, A1D

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 14, 2022, 7:30pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/3 "2022-01-14T19:30:10Z")

</div>

It should be that simple. How did you configure your template column?

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [January 14, 2022, 7:33pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/4 "2022-01-14T19:33:03Z")

</div>

I think the issue I am facing is that Column A must appear first when combined.

So when I do a template it try’s to search the two columns but cannot give a output because Column A is the same value

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 14, 2022, 7:34pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/5 "2022-01-14T19:34:48Z")

</div>

I still don’t understand. Can you show a screenshot of your template column configuration? All you need is two random values in your template (such as AB or XY). Replace the first one with Column A and replace the second one with Column B.

---

<div class="post-metadata">

**Author:** ![Conner\_Krofchick1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/conner_krofchick1/32/27182_2.png) [@Conner\_Krofchick1](https://community.glideapps.com/u/Conner_Krofchick1)\
**Post date:** [January 14, 2022, 7:41pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/6 "2022-01-14T19:41:16Z")

</div>

Thank you Jeff - I was using the template column incorrectly, it all works now 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [January 15, 2022, 7:41pm UTC](https://community.glideapps.com/t/combine-text-from-two-columns/37197/7 "2022-01-15T19:41:49Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
