combining 2 fields based on different data in each

[SuzanneMoore]

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

[Luke_C]

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?