I need to write a macro that transforms this sheet:
Into this:
I think it is some kind of transpose but it should repeat the two first columns when they have more than 1 value on their row.
Could you please help me?
I've been thinking of some ways to do it but none has actually worked.