Replace information in a column by summarized information of the same column grouped by ID

[Anonymous]

Hi, evebody

I am struggling in trying to replace values in the column MACHINE for the mode of MACHINE considering the table grouped by ID. The column machine may have wrong values pointed, thats why I want to extract the mode a replace. 

This is the example of before, as you can see ID 1444 has apointments of MACHINE 4 (mainly) and 1 (probably wrong appointment):

I need this result, replace values in MACHINE for the mode of each ID:

I filtered the column ID just to examplify the issue, but of course it has many other IDs on it.

I did not find nothing related to the operation I need in the community, could you help me?

[Anonymous · Accepted solution]

I finale could do it. Grouped the original table by ID creating a new table, after that I merged to a new table, this way cyclic reference error did not appear.

I'm gonna let this answer here in case.

[Anonymous]

Appreciate your help, let me know if I did not make a good explanation