Formula Returns with an array is truncated to a single cell

[bevsxyz]

I am using the flatpak version 7.4.0.163

I have been trying to use multiple functions that would return an array instead of a single cell, and the result is always truncated to the first cell. The function in question is not relevant, even table references suffer the same fate.

PFA ss of two such instances.

bits_batchmates is an array reference, which should ideally return a table. bits_batchmates[States] should return the column States. Instead, it returns the single state value, Andhra Pradesh.

• The return value for UNIQUE function

• Array reference

Note: Although it must be mentioned that any reductive calculations on these arrays return the expected values.