Forum Discussion
Repeat a value based on another column
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
2 Replies
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 👍
