Describe the data request within the formula

QUERY brings database-style selection to a Google spreadsheet. The source describes the formula as a data range, a query expression, and an optional header count. The expression determines which fields and records should appear, allowing a separate sheet to present information drawn from an existing list. This is useful when the working dataset should remain in place while another view answers a more specific question.

Make the header and range assumptions explicit

Check which rows contain the labels and where the actual records begin. The header argument helps the function interpret that structure, so it should reflect the real table rather than an assumed default. Begin with a simple selection and verify the returned columns and rows before adding conditions or more advanced operations. A clear connection between the original range and the resulting table makes the formula easier to adapt and maintain.

Build a Separate Results Sheet with QUERY