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 ...
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 👍
