Checking for unique value in a matrix and group column value assigned

Hello,

I'm working on a sheet I have to complete and I'm blocked 'cause I'm not able to find the right formula to get the result I need.

I have a sheet that contains 4 columns with the following content (consider the following just as an example. The real sheet contains more that 25,000 rows.

User ID Repository 1 Repository 2 Repository 3
001FG x
001FG x
10GA x
20PK x
20PK x
20PK x
21CC x
4C1D x

Now, the table contains the user id (unique ID) and three columns that stand for the access right the user has for accessing a specific repository.
This means that a User can have more than one occurence in the sheet because it could have rights to access different repository (i.e. the user 20PK can access all the repository).

What I should be able to do is to transform the table above to a new one with unique user id and the rights for each repository.
I would need something like this:

User ID Repository 1 Repository 2 Repository 3
001FG x x
10GA x
20PK x x x
21CC x
4C1D x

How can I do this by using a formula and not a macro?

Is there someone that can help me to solve this task?

Best regards,
J.