Skip to main content
Web Applications

Return to Answer

added 156 characters in body
Source Link
Daniele
Daniele
  • 2.4k
  • 2
  • 6
  • 14

Try something like:

=QUERY(
        {{sheet#1-range,index(substitute(sheet#1-range,sheet#1-range,"sheet1"))};
         {sheet#2-range,index(substitute(sheet#2-range,sheet#2-range,"sheet2"))};
         ...,
    "Select * where Col1 is not null")

Try something like:

=QUERY({{sheet#1-range,"sheet1"};{sheet#2-range,"sheet2"};...,"Select * where Col1 is not null")

Try something like:

=QUERY(
        {{sheet#1-range,index(substitute(sheet#1-range,sheet#1-range,"sheet1"))};
         {sheet#2-range,index(substitute(sheet#2-range,sheet#2-range,"sheet2"))};
         ...,
    "Select * where Col1 is not null")
Post Undeleted by Daniele
Post Deleted by Daniele
Source Link
Daniele
Daniele
  • 2.4k
  • 2
  • 6
  • 14

Try something like:

=QUERY({{sheet#1-range,"sheet1"};{sheet#2-range,"sheet2"};...,"Select * where Col1 is not null")