Forum Discussion

skutovicsakos's avatar
6 years ago

Merge two rows based on multiple column values

Hi all

 

The simplified version of the table looks like this:

 

 

 

 

 

 

And from that, I need something like the picture below, IF two rows' ID, Field and Type fields are the same, they should be merged while creating 2 new columns. (ones without a match, should be discarded)

 

 
 

 

 

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion

    Hi skutovicsakos ,

    if you crosspost your question in multiple forums, please indicate the other posts to avoid that people work on a question that has already been solved in the other forum.

    In general it would be better to avoid crossposts at all and choose the adequate forum in beforehand.