I have 2 rows for one user and need to take the data from field one from the second row and the data for field 2 from the first row. They have several other fields but they can be grouped.
FAIL
RITM0481828
Pass
AGRI
So I want both to say Pass for field one and both to show RITM0481828 for field 2
Can you expand on the logic? The easy answer is a multi-row formula tool, however it would be helpful to know some more requirements to get you the best answer, things like:
Will all users in the data set have 2 rows? Is there logic that if any of the rows is 'pass' for a user they all should be?
Is there significance to the RITM0481828 that indicates it takes precedence over AGRI? Maybe can go on length, prefix = RITM, etc?
