# Combining 2 identical columns into one

**URL:** <https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047>\
**Category:** Ask for Help\
**Created:** [February 14, 2025, 2:08am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047 "2025-02-14T02:08:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\
**Post date:** [February 14, 2025, 2:08am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/1 "2025-02-14T02:08:38Z")

</div>

Hello experts and mates!

I need your help to combine 2 identical columns just like Glide did in previous (but I don’t know how to do that again):

 ![Screenshot 2025-02-14 at 09.56.37](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/c/8c0dfb92237ef0da1917b7c220b62d2dbfd6e78e.png)

It will show like this in the Data tab:

 ![Screenshot 2025-02-14 at 09.59.35](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/a/9afb3b06f58b38505999e737c0ba242f66cf4ee4.png)

I need your guidance how to do that intentionally 🙂

Thank you for your kindness to help me!

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 14, 2025, 2:11am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/2 "2025-02-14T02:11:12Z")

</div>

Unfortunately, you can only do that with Google Sheet tables…

---

<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:** [February 14, 2025, 2:23am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/3 "2025-02-14T02:23:51Z")

</div>

Use a Make Array column to join them into an array.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 14, 2025, 2:29am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/4 "2025-02-14T02:29:22Z")

</div>

I understand what he mean. I use the multiple roles method with Google Sheet.

In Google Sheet, when you create let’s say 4 columns with the same name and a number incrementing (Role 1, Role 2, Role 3, Role n), Glide will make a “basic make array” column that you can also use as the role of the user. Meaning that you can add multiple roles to a user.

Make array is a computed column and can’t be use for row owners. Basic make array can.

---

<div class="post-metadata">

**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\
**Post date:** [February 14, 2025, 5:22am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/5 "2025-02-14T05:22:08Z")

</div>

Actually I did that on the Google Sheet, make 2 column named: Sektor 1 and Sektor 2. But this time Glide doesn’t seem to automatically make that “Basic Make Array”. I have refreshed the page several times.

The position of the columns in the Google Sheet is: ‘Sektor 1’, ‘Another Column’, …, ‘Sektor 2’. Do I have to re-arrange it side by side to make the magic happens?

---

<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:** [February 14, 2025, 5:59am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/6 "2025-02-14T05:59:52Z")

</div>

Yes, they must be next to each other.

---

<div class="post-metadata">

**Author:** ![Deny\_Pratama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deny_pratama/32/61099_2.png) [@Deny\_Pratama](https://community.glideapps.com/u/Deny_Pratama)\
**Post date:** [February 14, 2025, 11:16am UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/7 "2025-02-14T11:16:13Z")

</div>

I’ve tried it, and yes, that little magic happens! Now I understand a little deeper about how Glide sees the Google Sheet columns.

Thanks for your quick response, @Jeff_Hager and @MaximeBaker . Cheers. 🍺

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [February 14, 2025, 3:37pm UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/8 "2025-02-14T15:37:35Z")

</div>

Anytime!

---

<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:** [February 21, 2025, 3:38pm UTC](https://community.glideapps.com/t/combining-2-identical-columns-into-one/80047/9 "2025-02-21T15:38:20Z")

</div>

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