Merge two rows based on multiple column values

[skutovicsakos]

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)

[ImkeF]

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.