# Is there a way to merge a relationship column with lookup?

**URL:** https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461
**Category:** Ask for Help
**Created:** [October 11, 2022, 10:48am UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461 "2022-10-11T10:48:39Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)
#### Post date: [October 11, 2022, 10:48am UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461/1 "2022-10-11T10:48:40Z")

</div>

I have two columns - one that is a relationship column and another one there a lookup of relationship column.

Is it possible to merge them into another column?

 ![Screenshot 2022-10-11 at 11.45.06](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/5/c53bf448a3054c092647622f83c4ec2651c24071.png)

---

<div class="post-metadata">

### Author: ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [October 11, 2022, 10:52am UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461/2 "2022-10-11T10:52:46Z")

</div>

You can merge your columns into a group by adding " GroupName/ " in front of the headers of your columns in the data editor.

For example:

Plates/Tracking Lines  
Plates/TrackingLineKilnUnload

When you click on “Plates” which will be above the column headers, you’ll be able to collapse and uncollapse the group.

---

<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: [October 11, 2022, 10:55am UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461/3 "2022-10-11T10:55:47Z")

</div>

> [@KPT](#):
>
> Is it possible to merge them into another column?

(taking your question to mean something else that Nathaneal answered)

Short answer: No.

Longer Answer: Let’s pretend for a moment that it is possible. What would you expect the result to look like, and what would you do with it?

Probably what you could do is create another Lookup column that operates on your multiple relation. This would give you two lookup columns, both containing an array of values. And you could combine those using a MakeArray column.

---

<div class="post-metadata">

### Author: ![KPT](https://avatars.discourse-cdn.com/v4/letter/k/eb9ed0/32.png) [@KPT](https://community.glideapps.com/u/KPT)
#### Post date: [October 11, 2022, 12:26pm UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461/4 "2022-10-11T12:26:45Z")

</div>

I basically just want it to be a full list to easier do rollups and summarise things - but I can think of a few ways around it. It was just if it was possible as it would save me some columns.

---

<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: [October 12, 2022, 12:26pm UTC](https://community.glideapps.com/t/is-there-a-way-to-merge-a-relationship-column-with-lookup/51461/5 "2022-10-12T12:26:49Z")

</div>

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