title: How to query a list of (course) dates and return two rows for each date - to create two sessions on each of the course dates
body: <p>I'm using Google Sheets to build a schedule for <em>several</em> courses. The course dates are all set for the year and are the same for each course. Therefore I can pull the course dates for each course from a master list of course dates.</p>
  <p>However, with one instance of this schedule (i.e. one course), the course has <em><strong>two</strong></em> sessions for each course, whereas I can currently only query and return one row for each course date. So I'm trying to build a nested query (I think) to return two (or maybe 3) rows for each course date, ordered by date.</p>
  <p>I've searched for nested queries, but am not too familiar with them, hence cannot find anything which helps me resolve this problem.</p>
  <p>Here is a <a href="https://docs.google.com/spreadsheets/d/124BR5tFtZncFfbzLTuMMSTyylq2N-t6hAGNmq7SC1pk/edit?usp=sharing" rel="nofollow noreferrer">test sheet</a> with some data.</p>
  <p>Many thanks.
  Martin</p>