title: How to add extra text to Query results?
body: <p>I have a sheet with data that a Google Form is continually adding data to. Once the data is added, there is a subset that I need to have sectioned off to another sheet.</p>
  <p>I'm transposing the data so it sorts vertically for each Form's data, and the problem I'm running into is that I want each vertical selection to be individually labeled with the same consistent labels and I don't think I can make <code>CONCATENATE</code> work in this case (I would love to be proven wrong!).</p>
  <p>Here's a link to the sheet:
  <a href="https://docs.google.com/spreadsheets/d/1efOQRlKaJlffMnLd8f8oPZxJ57wVFGwKwVY3UW0savc/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1efOQRlKaJlffMnLd8f8oPZxJ57wVFGwKwVY3UW0savc/edit?usp=sharing</a></p>
  <p>Here's the formula I currently have in <code>A1</code> on the <code>'Credential Request Form'</code> sheet:</p>
  <p><code>=TRANSPOSE(QUERY('Onboarding Form Responses'!A2:J,&quot;Select F,B,C,D,G,A where A is not null order by A desc&quot;))</code></p>
  <p>This presents the data I want and in the order I want it, but without labels before the data (sorry, &quot;label&quot; might be the wrong word here). I've included an example of how I'd like the data to present in cells <code>A9:A13</code> on the same sheet.</p>
  <p>Is it possible to add those labels without a substantial amount of scripting?</p>