Data transformation - fill 3 or more columns

[#1]

Hello QV Experts, I have a problem with data transformationinto expected format. My data source looks like that:

And I really need it in that form:

I know, that I can use fill function in wizzard, but for 3 or 4 data levels? Is there possible to do it in script?

Do you have any idea, how to solve this problem?

I will be very grateful.

Ewe

[preminqlik]

well, upload sample excel here, we can do that by looping after using Peek

hint: first you need to load orginal data as it is then you need to start peeking