Complex transpose table

UPDATE
Hi,
I’m new in Knime, I try to make transposition but it’s not simple.
How can I leave the left table for the right one.

When I try transpose, I have:


and this version is not I want.

In the Excel file, the Input Sheet is example of Input and Output is example of Output.

Fake data.xlsx (15.8 KB)

thanks