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

Thanks, both great responses.

Could I ask for a quick breakdown of the logic for each? I became a little lost when we began using the ROW function, and it would be great if I could understand this and be able to adapt it myself in future projects. In particular:

"INDEX((unit_equipment_editor[has_stat]<>TRUE)*10^10+ROW(unit_equipment_editor[has_stat]),0),ROW(9:9))),"")"

This part of Siva's formula.

Not sure if this is the correct etiquette here, so please excuse me if I am asking too much

Anyway, I would consider this problem solved for now, so again - a huge thanks for the quick replies!

Dave

Awesome!

Yes, that seems to make sense. I guess part of the battle is just knowing the different steps in logic you can take. I'll definitely be using this again in the future, so thanks again :D