title: How can I use Query() and Flatten() in Google Sheets to reference a variable amount of rows?
body: <p>I'm looking to take a data download in this format
  <a href="https://i.stack.imgur.com/qUx2x.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qUx2x.png" alt="current data" /></a></p>
  <p>It is the Item ID, Value, Date changed to that value for the history of that Item.
  Each Item has been changed a different number of times.</p>
  <p>I'd like it to look something more like this.
  <a href="https://i.stack.imgur.com/Et4Wr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Et4Wr.png" alt="how Id like the data" /></a>
  Where each Item ID with the value and the date changed to the value having their own row.</p>
  <p>I've tried to use different forms of Query() and Flatten() but can't seem to get it right as I am quite a novice at this.</p>
  <p>I attached my sample sheet - I'd really appreciate the help
  <a href="https://docs.google.com/spreadsheets/d/1SvlOX7D57_V3FnYNsKAAmDMvnUv5jEZgr79_593atdw/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1SvlOX7D57_V3FnYNsKAAmDMvnUv5jEZgr79_593atdw/edit?usp=sharing</a></p>