# Bring Multiple Row items Into one row different columns

**URL:** <https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210>\
**Category:** Ask for Help\
**Created:** [January 15, 2022, 4:51am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210 "2022-01-15T04:51:01Z")\
**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 15, 2022, 4:51am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/1 "2022-01-15T04:51:01Z")

</div>

Hey all,

I was wondering if there were any thoughts on a way that I can bring values from multiple rows into corresponding rows but multiple columns.

To explain better see the example below:

This is the multiple rows (the common value is A)

A: 1223  
A: 1226  
B: 1225  
B: 1228

Lookup by A: returns = 1223 and 1226

Is there any way to have both 1223 and 1226 show up on both rows for each item (for example 1226 on the row of 1223 but different column and 1223 on row of 1226 in different column)

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [January 15, 2022, 4:53am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/2 "2022-01-15T04:53:40Z")

</div>

You can create relations within the table with the common value!  
But the relation would also include the current row as well which cane filtered out.  
So you would have the data of all rows with common value in all the corresponding rows!

---

<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 15, 2022, 4:55am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/3 "2022-01-15T04:55:50Z")

</div>

Yes i have this so far, How do I filter out the current row item?

---

<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 15, 2022, 4:56am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/4 "2022-01-15T04:56:20Z")

</div>

![Screen Shot 2022-01-14 at 11.56.04 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/cad19330403ab4866ac94e642661f93bda487c86.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 15, 2022, 5:07am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/5 "2022-01-15T05:07:21Z")

</div>

Have a look at the [Remove Element from Array](https://www.glideapps.com/plugins/remove-from) plugin.

---

<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 15, 2022, 5:19am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/6 "2022-01-15T05:19:07Z")

</div>

This is very cool! Pretty amazing how powerful Glide is and becoming 🙂

---

<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 16, 2022, 5:20am UTC](https://community.glideapps.com/t/bring-multiple-row-items-into-one-row-different-columns/37210/7 "2022-01-16T05:20:06Z")

</div>

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