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!

Myals Jones

If one of the lists is longer than the other, how could blanks be removed?

jmyzk_cloudsmart_jp

Do Example 1 and 2 have some value, like a name associated with the times?

For example,

Example 1

Name, Time 1

Juni, 8:00 AM

Example 2

Name, Time 2

Juni, 11:00 AM

Myals Jones

They do not, but I managed to figure it out by just sorting which didn't eliminate the blanks altogether but at least grouped together my values and put the blanks at the end which is fine for my purposes. Thank you for your help!