# How to 'join down'

**URL:** <https://forum.openrefine.org/t/how-to-join-down/1823>\
**Category:** Support and Helpdesk\
**Created:** [October 14, 2024, 8:52pm UTC](https://forum.openrefine.org/t/how-to-join-down/1823 "2024-10-14T20:52:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![archilecteur](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/archilecteur/32/1099_2.png) [@archilecteur](https://forum.openrefine.org/u/archilecteur)\
**Post date:** [October 14, 2024, 8:52pm UTC](https://forum.openrefine.org/t/how-to-join-down/1823/1 "2024-10-14T20:52:32Z")

</div>

Hello OR Community / Overmind,

I'm facing a challenge with some tables where the authors' information is split across multiple rows. I need to consolidate these values so that all data related to authors is combined into a single row, but the lowest instead of the highest one.

I might be missing an obvious solution, so I'd appreciate any assistance in figuring out how to achieve this.

 ![joindown](https://europe1.discourse-cdn.com/flex017/uploads/openrefine/original/2X/5/545d10610f2d6539677d50a5fe8244933ffc8013.jpeg)

---

<div class="post-metadata">

**Author:** ![ostephens](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/ostephens/32/8_2.png) [@ostephens](https://forum.openrefine.org/u/ostephens)\
**Post date:** [October 14, 2024, 9:29pm UTC](https://forum.openrefine.org/t/how-to-join-down/1823/2 "2024-10-14T21:29:25Z")

</div>

Hi @archilecteur. I think the approach I'd take is:

1. Add a column using "rowIndex" (e.g. from `auteur` column drop down do Edit Column -\> Add column based on this column, expression `rowIndex`
2. Do a reverse numeric Sort by this column
3. Reorder rows permanently

Now the rows are in the reverse order you move the `resume` column to the beginning of the project and then use the usual "join multi-valued cells" to combine your `auteur` cells

Will that work for you?

---

<div class="post-metadata">

**Author:** ![archilecteur](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/archilecteur/32/1099_2.png) [@archilecteur](https://forum.openrefine.org/u/archilecteur)\
**Post date:** [October 14, 2024, 10:36pm UTC](https://forum.openrefine.org/t/how-to-join-down/1823/3 "2024-10-14T22:36:57Z")

</div>

As always @ostephens, you've come up with a solution, if not an idea, to get the ball rolling again. From there, I was able to solve the problem. Many thanks to you.

---

<div class="post-metadata">

**Author:** ![AZEEZ\_HAMMED](https://dub1.discourse-cdn.com/flex017/user_avatar/forum.openrefine.org/azeez_hammed/32/1249_2.png) [@AZEEZ\_HAMMED](https://forum.openrefine.org/u/AZEEZ_HAMMED)\
**Post date:** [October 15, 2024, 12:03am UTC](https://forum.openrefine.org/t/how-to-join-down/1823/4 "2024-10-15T00:03:24Z")

</div>

Can you show me example