The master table is growing by an additional column each week. There are empty cells that I can’t fill with a 0 without boogering up the import.

How do I return the most current reported week, and the last 3 weeks. Like what’s shown below the main table. The example has a header, the actual table has no header

I tried Index, counta, arrays etc…Empty cells are the road block