Missing value based on groups

[keeprollin]

In my workflow, the final output that I receive is exactly how it is shown in the attached excel sheet (Also in the table shown below). However, I have realized that the value in column 'age' is missing for a different group within same id and name even though the value of age can be found for another group for the same id and name. Is there a way that I can populate the value of age to other groups if it is present for at least one group within same name and id?

Id	Name	Group	Salary	Age
1	Kevin	A	2000	49
1	Kevin	B	3000
2	Bob	A	2500	55
2	Bob	C	3500	55
2	Bob	D	4000	55

In my final output, I would want the value '49' to be shown for Group B for Kevin. Can someone please help me with a solution?

[Jonathan-Sherman · Accepted solution]

Hi @keeprollin,

You could summarise your table and join back the age data onto your original table:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan