Records on the same line

[BautistaC888]

Hello,

I need to merge the records with the same ID into 1 full line.

Example:

Input-

Desired output:

Thank you.

[KarolinaRoza · Accepted solution]

Hi @BautistaC888

You can use Summarize tool:

- group by ID,

- max by other fields.

In case you have two different  values in both fields it may not work as expected but for the same values or null() it works.

Karolina

[Emil_Kos · Accepted solution]

Hi @BautistaC888,

You can also use concatenation and remove duplicated positions: