How to reverse rows in Google Spreadsheets?

Question

Google Sheets

How to reverse rows in Google Spreadsheets?

Answer 1

Numbered column and SORT function .

Answer 2

Wrote for columns based on
=INDEX($M$21:$Q$21, 1, COLUMN($Q$21)-COLUMN(M21)+1)
range locked 1 row, 5 columns,
for rows would be
=INDEX($M$21: $M$25, row($Q$21)-row(q25)+1, 1))
Works if the size of the range is hard-coded, if it increases, then empty lines must be deleted and the length of the range determined by the forumula