Need to pull values across several sheets and columns into 1 column stacked, not combined.

Myals Jones

I am looking to pull values from the Time 1 column of Example 1 sheet and the Time 2 column of the Example 2 sheet into the Time column on my Reference sheet with those values listed, not combined. Below images may help explain what I am looking for:

jmyzk_cloudsmart_jp

Hi @Myals Jones

Here is a solution.

https://app.smartsheet.com/b/publish?EQBCT=2e1544a250e549ad9cbb256758786134

[INT] =INT(([Row ID]@row + 1) / 2)
[Time] =IF(MOD([Row ID]@row, 2) = 1, [Time 1]@row, [Time 2]@row)
[Time 1] =INDEX({Example 1 : Time 1}, INT@row)
[Time 2] =INDEX({Example 2 : Time 2}, INT@row)

jmyzk_cloudsmart_jp

Hi @Myals Jones

Here is a solution.

https://app.smartsheet.com/b/publish?EQBCT=2e1544a250e549ad9cbb256758786134

[INT] =INT(([Row ID]@row + 1) / 2)
[Time] =IF(MOD([Row ID]@row, 2) = 1, [Time 1]@row, [Time 2]@row)
[Time 1] =INDEX({Example 1 : Time 1}, INT@row)
[Time 2] =INDEX({Example 2 : Time 2}, INT@row)

Myals Jones

Thank you so much for your help!

jmyzk_cloudsmart_jp

Happy to help!