How can I use Query() and Flatten() in Google Sheets to reference a variable amount of rows?

Question

I'm looking to take a data download in this format

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.

I'd like it to look something more like this. Where each Item ID with the value and the date changed to the value having their own row.

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.

I attached my sample sheet - I'd really appreciate the help https://docs.google.com/spreadsheets/d/1SvlOX7D57_V3FnYNsKAAmDMvnUv5jEZgr79_593atdw/edit?usp=sharing

Answer 1

use:

=INDEX(QUERY(SPLIT(FLATTEN(Data!A2:A&"×"&Data!B2:Y&"×"&Data!C2:Z), 
 "×",, ), "where Col3 > 44444"))