Solved Data transformation

[Dico]

Hello everyone,

I have a transformation exercise that is a bit complicated for me and I would like please your help.
I put a maximum of explanations in "Template" of the "Output" file

Is it possible with Power query?

For information I have the Excel 2019 version

Thank you in advance

Regards

 

[p45cal]

See attached. Obviously the file is in a different location so change as follows:

 

[Dico]

Great p45cal,
Thank you very much for your help and good work.
I will test on my original file, I think it will work without problem
Thanks again for everything

Regards