Forum Discussion

LOAM's avatar
LOAM
Frequent Visitor
3 years ago

Excel Table transformation

Hello

 

How can I transforme this table...

Départsplate formeAG Arrivée CP
Clermont ferrandInterpoolZiegler Rennes35
Clermont ferrandBenetoTam TAM14
Clermont ferrandDucros15
Clermont ferrandZ Vannes56
Clermont ferrandDGSCFD63

 

Into this one

Many Thanks

 

DépartsArrivéeCP
Clermont ferrandInterpool35
InterpoolZiegler Rennes35
Clermont ferrandBeneto14
BenetoTam TAM14
Clermont ferrandDucros15
Clermont ferrandZ Vannes56
Clermont ferrandDGS63
DGSCFD63
Need Help

3 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    3 years ago

    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 !

     

  • LOAM's avatar
    LOAM
    Frequent Visitor
    3 years ago

    HI,

     

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

    What is UI ?

     

    Have a good day

    • serpiva64's avatar
      serpiva64
      Solution Sage
      3 years ago

      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.