Find last MATCH for each row on a 2D running array with ONE "spill" formula

Below is a short snippet of a particular column with a list of stock tickers, which is part of a huge multi-column table:

In order to get to a 2D array of that column, accumulating the rows as the column progresses down, I went through the usual procedure through the formula

=IF(--(SEQUENCE(;ROWS($A$2:$A$21);0)<SEQUENCE(ROWS($A$2:$A$21)))=1;TRANSPOSE($A$2:$A$21);"")

which produced the yellow shaded array pictured below:

Then from the above array I need to extract the ROW number of each last MATCH out of the TRANSPOSED/SORT/UNIQUE list of tickers first pictured UP above on the first image.

=TRANSPOSE(SORT(UNIQUE($A$2:$A$21)))

If I were to do that by individual cell, then we're talking about a pretty basic solution, such as this

=MAX(SEQUENCE(;COLUMNS($C2:$V2))*--($C2:$V2=X$1))

and then just drag that down and across a 20 ROWS by 9 COLUMNS array to get the job done.

However, that solution won't work for me, as I'm embedding that onto another much more complex dynamic formula that is supposed to automatically pick up all new rows and tickers that will come up in the future, since we're talking about a live growing table, and I don't want to worry about checking the formula span every time I update the input schedule.

Since the Excel team recently released a few great functions that work well with one-dimensional dynamic arrays, I made use of the BYROW function in order to get that individual-cell solution and turn it into a dynamic solution that "spills" down each correspondent ticker column as the source list grows in rows

=BYROW($C$2#;LAMBDA(Ultimo_Instrum_Por_Linha;MAX(IF(Ultimo_Instrum_Por_Linha=X$1;COLUMN(Ultimo_Instrum_Por_Linha)-MIN(COLUMN(Ultimo_Instrum_Por_Linha))+1))))

and that produced me the produced the green shaded array that follows:

But then there's another catch: please note that the formula works for each individual ticker, however every time a new ticker comes up on an additional column further to the right of the spreadsheet, the formula won't automatically pick that up.

And remember that this formula will go into another formula, so dragging it across additional "placeholder" columns won't do the job since this won't even be sitting anywhere!

So, as the post title says, I need a 2-dimensional formula for that goal: in other words, a formula that will "spill" the results down the ROWS and across the COLUMNS.

Unfortunately, an Excel native "BY2DARRAY" function hasn't been created yet for that purpose, and that's the workaround I need to get to in order to crack that nut.

I'm currently working on a combination of BYROW and BYCOL via LET, but still having a hard time to reach a final solution...

Any ideas?!

P.S.:

Please find attached the actual workbook file.