Repeat a value based on another column

[MathieuF]

Good morning,
I change my wish to try to find a solution.
In my data, each task_id is associated with a user_name but it is not repeated over the entire column for the same task_id.
How to repeat in another column the user_name associated with a task_id?

Thank you very much.

https://drive.google.com/file/d/1j-P7F-Prw_5y-3QmV8WzE8GdApm1X5NX/view?usp=drive_link

[DOLEARY85]

Hi,

you can potentially do this by using the group by option:

1. Select Task_Id as the group

2. Add a username column under aggregation and select Max as the operation of the username colum

3. Add a second aggegation as All Rows

Click okay and expand the all rows column - you should have a new username column (i called it username1) with a completed list.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[MathieuF]

Hello @DOLEARY85 

Thank you very much for your help.
The file I made available is a small file. My real file weighs several GB and the data is on Google big query.
The manipulation you gave me seems to take a long time.