Unpivot/Pivot multiple steps

[SvenvandenHil]

We have a form which is filled in on a single ExcelSheet. For every day in the year the form gets copied down. I have in this link an example for 1 day (Test Query File). So if there will be a new day these lines will be copied below. So every day will look exactly the same. Only there will be always other cells filled in and cells will have other values. So I want to make a table which can be used in PowerBI to make visuals for certain products. I got the form in the query, and tried to pivot, unpivot, transpose, etc. But couldn't seem to find the correct way to make this a more readable table for PowerBI. Anyone of you who can help me out?

The document is partialy in Dutch.  

[Anonymous]

Hi @SvenvandenHil 

Based on the information you have offered, what is the final output you want? can you provide some sample output so that can provide more suggestion for you to refer to.

Best Regards!

Yolo Zhu

[SvenvandenHil]

Hi @Anonymous,

So this form contains the factory were the product gets tested (red outline).
The product information (Blue outline).

And the product gets tested mutiple times up to 8 times in some cases (yellow outline).

I want to build a report were you can see the test results per times tested, per type of product and per factory.