# Find Value from Previous Row

**URL:** <https://community.glideapps.com/t/find-value-from-previous-row/56330>\
**Category:** Ask for Help\
**Created:** [January 4, 2023, 3:12pm UTC](https://community.glideapps.com/t/find-value-from-previous-row/56330 "2023-01-04T15:12:24Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [January 5, 2023, 1:32am UTC](https://community.glideapps.com/t/find-value-from-previous-row/56330/4 "2023-01-05T01:32:51Z")

</div>

So I assume you store each place’s address/coordinates?

What you can do is this:

- Create an index for each row, as described below

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [[Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

Please note that the index should be related to each “trip” only, since you want to index each row based only on their respective list. You should have a “Trip ID” that is unique to each trip.

- Create a Math column, name it “Previous Index”, take the index from the 1st step, minus 1.
- Create a Template column, name it “Previous Index Temp”, the template should join the “Previous index” and the “Trip ID”. E.g: 1 - abcdef.
- Create another Template column, name it “Current Index Temp”, joining the “Current Index” (step 1) and the “Trip ID”.
- Create a relation from the “Previous Index Temp” column to the “Current Index Temp”.
- Return the “Destination address/coordinates” from the relation. It should give you the address/coordinates of place B, D, F etc in Darren’s example.

---

_[View the full topic](https://community.glideapps.com/t/find-value-from-previous-row/56330)._