How to sort out only rows with values based on certain criteras

Hello

We are working on a measurment tool in our production where the operator need to write the values he/she measured after production.
We are not measuring all pcs but on a frequency based on 8 parts and multiples of this.
Everytime the operator have produced they add 8 new produced with one click. But sometimes the excel tells the operator he/she needs to do a measurment and write the result to the excel.
I have a lot of inputs now that I want to make a chart to see how the values varies. Unfortunately many rows does not have values and a chart would look very strange.
I'd like to use a filter function that only results in the rows where values are added and the user should be able to make inputs like date, part number etc to look for the correct part number only.

In the attached excel I have the data and also describes how the result should look like.
Does anyone here knows how I can manage this with a function in any way?
When I have a working result I can easily make the chart work.


/Anders

This seems to do what you want:

=LET(a,A2:B153,b,FILTER(J2:N153,J1:N1=T9),h,HSTACK(a,b),FILTER(h,(A2:A153>=T7)*(A2:A153<=T8)*(F2:F153=T6)*(b<>"")))

You're welcome.