# Pulling Data into one row

**URL:** <https://community.glideapps.com/t/pulling-data-into-one-row/37130>\
**Category:** Ask for Help\
**Created:** [January 13, 2022, 6:49pm UTC](https://community.glideapps.com/t/pulling-data-into-one-row/37130 "2022-01-13T18:49:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Boomer\_Rose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomer_rose/32/29375_2.png) [@Boomer\_Rose](https://community.glideapps.com/u/Boomer_Rose)\
**Post date:** [January 13, 2022, 6:49pm UTC](https://community.glideapps.com/t/pulling-data-into-one-row/37130/1 "2022-01-13T18:49:51Z")

</div>

Hello Fellow Gliders,  
I am working in glide pages currently, and trying to figure out a way to get the data from the 5 most recent rows of a user, compiled into one row so that I can eventually use integration to compile the new row into a PDF, or google doc.

I am assuming that using set columns, joined lists and look up columns I can complete this. I am wondering if anyone else is trying to achieve this task.

With gratitude,

Boomer

---

<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:** [January 13, 2022, 11:01pm UTC](https://community.glideapps.com/t/pulling-data-into-one-row/37130/2 "2022-01-13T23:01:30Z")

</div>

Have you tried a relation column linking to the user, and then 5 single value columns, each getting a column value from one of the last 5 rows from the end of that relation?

---

<div class="post-metadata">

**Author:** ![Boomer\_Rose](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/boomer_rose/32/29375_2.png) [@Boomer\_Rose](https://community.glideapps.com/u/Boomer_Rose)\
**Post date:** [January 14, 2022, 2:27am UTC](https://community.glideapps.com/t/pulling-data-into-one-row/37130/3 "2022-01-14T02:27:08Z")

</div>

@jeff_hager You rock. I don’t usually use \*single values much for the apps I need to build. But this is a life saver. Thank you so much

---

<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 15, 2022, 2:27am UTC](https://community.glideapps.com/t/pulling-data-into-one-row/37130/4 "2022-01-15T02:27:27Z")

</div>

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