This was my thinking too - data tables can often do this.

The negative of data tables is that it massively slows down your spreadsheet, and cause some weird errors/glitches, but it’s essentially the same thing.