Forum Discussion

nilo0123's avatar
nilo0123
New Member
3 years ago
Solved

organize data from a table with multiple data for one ID

Hi, I'm french so i apologize for bad expression I have an issue to organize my data   I have one table with those collum : ID / Contract ID / statut / Reponse statut ID Contract ID Statut ...
  • v-jingzhang's avatar
    3 years ago

    Hi nilo0123 

     

    Not sure if this is what you want. You can also try selecting the last three columns at the same time, then removing duplicated rows. This uses the Table.Distinct function too. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!