Why doesn't the formula =SORT({A2:C6;F2:H6},3,1) work?

I am running Excel365 on a Mac. I want to combine the two sets of data a2:c5 and f2:h4 into a single list, but my formula in the heading

Formula:

Please Login or Register  to view this content.

does not seem to work. It just sits there as if it was text, not even an error message. Is this a problem with Mac, or a problem with my use of the curly brackets?. I have also tried replacing the semicolon with a comma, but that does not help (error message).

The example shown is a very simplified version of a very large and complex spreadsheet. I know that in this simple example I could just copy and paste the two ranges together and then sort them, but that's not practical in my big spreadsheet because the data is constantly changing both in content and size. I'm looking for the simplest formula possible.

By the way, I have run this problem through a number of AI bots, including a few specialising in Excel solutions, but not one of them has come up with a working formula. Any suggestions for an Excel bot which works well, would be appreciated.

Screenshot 2024-01-29 at 09.07.30.png

Originally Posted by AliGW

Your desired output is not in chronological order.

Correct. How careless of me!

Thank you for bringing the VSTACK function to my attention. It is just what I need. It's a pity that none of the Excel AI bots mentioned =VSTACK.

I'm still wondering why my original formula doesn't work. Well that's not so important now you have solved this for me!
=SORT(VSTACK(A2:C5,F2:H4),3,1)

Originally Posted by TMS

Try VSTACKing the ranges before the sort.

Thank you TMS for mentiong the VSTACK function. Please see my reply to AliGW.

You guys are clearly better than the AI Bots, even the ones which claim to be good at Excel!

Thank you AliGW. All done! Humans still rule the intelligence world. AI Bots are very good at answering "general knowledge" questions and "problem solving" questions where I could figure out the answer myself or with a google search, but they are not much good when there is a question that has stumped me and the solution is not easily found with a google search.