what you need is to unwrap it first and then transpose.
Try this code, it shoul do what you need. You just need to name the fields correctly at the end and you should be all set.
(txt, codepage is 1252, no labels, delimiter is ';', msq, filters(
Remove(Row, Pos(Top, 1)),
Unwrap(Col, Pos(Top, 5)),
Unwrap(Col, Pos(Top, 3)),
Hope it helps.
Thank you, it is really helpful.
Just to add to discussion: I noticed that while loading data if you get into "Enable Transformational Step".
It gives you visual interface to modify/transform the actual data without the need for you to code and remember the syntax.
From there you can unwrap and transform data. In addition, you can add/delete rows and columns.