QUERY() with Sheetname

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):

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

Leave a Reply

Your email address will not be published. Required fields are marked *