Records on the same line

Question

Hello,

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

Example:

Input-

Desired output:

Thank you.

SAMEROW.yxmd

KarolinaRoza · Accepted Answer

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 Answer

Hi @BautistaC888,

You can also use concatenation and remove duplicated positions: