Forum Discussion
Joining content from different sheets
I have several sheets with identical headers. I would like to join them in a separate sheet and sort them. On Google Sheets, it is very simple: =SORT({Sheet1!A2:D100;Sheet2!A2:D100;Sheet3!A2:D100}...
Excel doesn't support UNION, at least directly. Thus I'd do that with Power Query - query one by one sheets, append and sort, return to new sheet.