Dynamic table automatic adjustments

Hello,

I have a formula which auto-populates cells based on the number of rows in combination with an offset function. Essentially, if you type a value into cell A2, the same value will automatically populate up to cell A25. However, this is not compatible with a table. Any ideas?

Attached is the sample. Column A demonstrates what is currently happening. Column D is a workaround, but I don't want to have to expand the table preemptively. Column G is what I want to happen, but with table format.


DynamicTable.xlsx

Thanks!

Continuing to struggle. Any ideas?