Excel Table transformation

[LOAM]

Hello

How can I transforme this table...

Départs	plate forme	AG Arrivée	CP
Clermont ferrand	Interpool	Ziegler Rennes	35
Clermont ferrand	Beneto	Tam TAM	14
Clermont ferrand	Ducros	15
Clermont ferrand	Z Vannes	56
Clermont ferrand	DGS	CFD	63

Into this one

Many Thanks

Départs	Arrivée	CP
Clermont ferrand	Interpool	35
Interpool	Ziegler Rennes	35
Clermont ferrand	Beneto	14
Beneto	Tam TAM	14
Clermont ferrand	Ducros	15
Clermont ferrand	Z Vannes	56
Clermont ferrand	DGS	63
DGS	CFD	63

[LOAM]

HI,

Thank you , but it isn't clear for me.

What is UI ?

Have a good day

[serpiva64]

UI is User Interface (in this case of Power Query).

Try to repeat the steps of the PBIX file i posted then if you have some problem i can lead you to the result.

[serpiva64]

Hi,

You can obtain it only using UI as you can see in the attached file

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !