I have several sheets with identical headers. I want to display their content on a separate sheet by a custom SORT.
I am using Excel Office 365
In Google Sheets is pretty simple:
=SORT({SHEET1!A2:D100;SHEET2!A2:D100;SHEET3!A2:D100},3,1)
Your help is greatly appreciated.
Bookmarks