Dynamic Array Spill and Sort into 2 Columns

Hello,

I'm not sure if this is possible with Dynamic Arrays but I'd like to confine the Spill into two columns using a maximum of 5 rows - while also Sorting on the sum of the Total. My spreadsheet is formatted in such a way that there are more Spill values than my layout will allow - hence the need to spill horizontally after 5 values are reached. I know I can use Sequence to limit the number of items in the Spill but I can't figure out how to make the second column pick up where the first left off. Furthermore, I'm not getting the SORT or SORTBY functions on the SUM of the Total column to work properly.

SOURCE TABLE
Name Dividend Date Total
Arizona 1/31/21 $345.00
Maine 4/15/21 $216.00
Georgia 3/15/21 $267.00
California 8/9/21 $589.00
Illinois 9/7/21 $246.00
Florida 12/1/21 $987.00
Georgia 2/28/21 $147.00
Alabama 4/15/21 $753.00
Maine 6/12/21 $23.00
Arizona 7/15/21 $237.00
Illinois 3/13/21 $687.00
Washington 11/23/21 $237.00
New York 2/9/21 $975.00
Maine 11/6/21 $764.00

My current formula (invalid Sequence & Sort additions removed)
Name Column

Formula:

Please Login or Register  to view this content.

Date Column

Formula:

Please Login or Register  to view this content.

If Dynamic Arrays don't support this, is there another way to accomplish what I'm asking?
Thanks

Thanks @Bo_Ry,

This almost works except if a Name has two different dates - like "Arizona" having a Dividend in both 2020 and 2021, the result shows Arizona multiple times. (I just changed one of teh Arizona rows to 2020 from 2021 and got the result below:

Florida 987 Arizona 345
Illinois 933 Arizona 345
Maine 787 Arizona 345
California 589 Arizona 345
Georgia 414 Arizona 345

Yes! - this worked. I made a slight modification of replacing the hard coded "2021" with YEAR(TODAY()) to support the current year and that worked perfectly.

That said, I would like to better understand how this actually works. Looking at the code, how does it force the Spill values for the second set of columns (starting at column 4) - skipping Column 3? I'm not seeing how the function populates 1&2, skips 3 then populates 4&5. I can see the CHOOSE within IfError expands the total number of columns but what makes it skip column #3?

I ask because I might want to add a blank column between the Name and the Total in both sets in cases where the Name text is too long for the cell width. If I could understand how each value is inserted into which column,. I can modify to add the blank column myself.