# How to: combine 2 look up columns

**URL:** https://community.glideapps.com/t/how-to-combine-2-look-up-columns/64029
**Category:** Ask for Help
**Created:** [July 18, 2023, 2:19am UTC](https://community.glideapps.com/t/how-to-combine-2-look-up-columns/64029 "2023-07-18T02:19:08Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [July 18, 2023, 2:19am UTC](https://community.glideapps.com/t/how-to-combine-2-look-up-columns/64029/1 "2023-07-18T02:19:08Z")

</div>

I’m looking to merge 2 lookup columns (with numbers) to create an average.  
I saw here in the community that I could use an “append array” to combine them:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/61377f073611baf12e488e3e72caee883dac8949.png)

But then when I tried to get an average with a rollup column, it only returned these options:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f51226e255155a972c37cc80dea72702fa805cc.png)

Is there a different way to combine these columns to get an average? I’m looking to display a business rating.

Thanks!

---

<div class="post-metadata">

### Author: ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [July 18, 2023, 2:40am UTC](https://community.glideapps.com/t/how-to-combine-2-look-up-columns/64029/2 "2023-07-18T02:40:18Z")

</div>

Append Array converts arrays to strings. Try the much more useful “Make Array” column instead.

---

<div class="post-metadata">

### Author: ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [July 18, 2023, 2:46am UTC](https://community.glideapps.com/t/how-to-combine-2-look-up-columns/64029/3 "2023-07-18T02:46:13Z")

</div>

AH! perfect thank you!