Dynamic Drag-Down of Formula Based On Other Cells

Hi all,
I've had a similar issue in the past and this amazing forum helped me out no end, so hopefully you can resolve this new issue as well?

Basically I would like a simple if formula to work across all of my data dynamically rather than being dragged down because at present I have this formula in cell C2:

Formula:

Please Login or Register  to view this content.

Then I drag that formula down 100 rows, however I will eventually have more than 100 rows and I can't just keep pulling it down. (Similarly I can't drag it down 10,000 rows now as I will eventually surpass 10,000 rows and as I'm heading there my workbook will be so slow!)

Ideally I'd love a simple method or formula that I can adapt in future which basically drags down a formula x times based on other conditions.
I have thought about tables and dynamic ranges but can't find a way to successfully adapt them into my formula. I've attached a sample workbook showing what I would like to achieve if possible, albeit this attachment is on a much smaller scale.

Let me know if you need any other information or if I need further explain anything. Thank you in advance.
EricDonk

Delete ALL expected results. Use:

=BYROW(A2:A10000&B2:B10000,LAMBDA(z,IF(z<>"","Stats Changed","")))

no copy - paste needed.