title: How to fix error: 'Array result was not expanded because it would overwrite data in __'
body: <p>I set up this spreadsheet to take attendance over Zoom each Am with my students. Students fill out a Google Form to check in. Their data goes into a connected spreadsheet, which in turn goes into a sheet displaying student attendance.<br />
  <strong>Prior to any student data being entered</strong>, the cells in rows 3-6 have an error message:</p>
  <blockquote>
  <p>Error: Query completed with an empty output.</p>
  </blockquote>
  <p>Then when a student name populates one of these cells, the following message appears:</p>
  <blockquote>
  <p>Error: Array result was not expanded because it would overwrite data in G3.</p>
  </blockquote>
  <p><strong>What I want to happen is for a student name to be displayed (complete with conditional formatting).</strong></p>
  <p>Here's a link to the spreadsheet: <a href="https://docs.google.com/spreadsheets/d/1DpERPaq8yIwDKHkp4T463D6GL5WHAVwHAVYqGmHNJxQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1DpERPaq8yIwDKHkp4T463D6GL5WHAVwHAVYqGmHNJxQ/edit?usp=sharing</a></p>