Check next row if value is, "FALSE," if "TRUE," return specified value from this row

Hi,

Completely new here, I've been browsing for a solution, but can't quite find what I'm looking for. I'd be incredibly grateful if anyone could help me get under way.

I've attached a mock-up of what I am working on to compliment the description:

I have a, "desired_value," on table 1. There is another column within table 1 that is set to either "true" or "false."

In table 2, I require the "desired_value" of all rows that are marked "true" from table 1 in a sequential list, with no spaces or zeroes.

If possible I'd like to achieve this without using a macro.

Thanks, and looking forward to your support,

Dave