How to QUERY() with a column for the sheetname, or sheetnames from multiple sheets.
Important note:
* In the custom array {}, use commas to separate columns and semicolons to separate rows
Sheet (to copy):
https://docs.google.com/spreadsheets/d/1Q0kAwUQkj9i3M3qJMUX9_Fwgkaeo7cc26TRhW0irnIo/edit#gid=1970274019
Formula:
=QUERY({
ARRAYFORMULA(IF(LEN(‘Location 1′!A2:A),”Location 1″,)),’Location 1’!A2:B;
ARRAYFORMULA(IF(LEN(‘Location 2′!A2:A),”Location 2″,)),’Location 2’!A2:B},
“Select * where Col1 is not null order by Col3”)
Connect with me:
• spencer.farris@gmail.com
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305