Compiling and sorting a table at the same time

[excelos]

Hello

I have a table (not formatted as table) that the first column is an array formula and the other columns are formulas calculating on the first column.
Whenever the data changes and the first column array length changes, I re-fill the formulas of the other columns so that the table is complete.

I want to always sort this table in a specific way. To do that, I now compile the table in one area of the spreadsheet and then I use SORT and repeat the table in another area of the spreadsheet which is the final format that I will be using.

Is there a way to eliminate this 'helper table' step and compile and sort the table in one place in the spreadsheet? But I need not to make the formulas too big. (I was thinking to create the table with a SEQUENCE formula and then nest this in a SORT formula but I reckon it will be too big)

Thanks!

 

[excelos]

Bump!

 

[Fluff]

You are more likely to get help, if you
1) Provide some sample data using the XL2BB add-in, that shows your original data.
2) Provide the formula you are currently using & the results they give.
3) Show what you want as the final outcome.

So far you have just given us nothing to work with.