Combine 2 rows

[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

[aatalai]

@SuzanneMoore look at the muli row tool, you might need 2, one for each column. Let me know how you get on

[griffinwelsh]

You can break off each field in a select tool. Use select records after each select tool to select relevant records. Then join back together. Sample is attached.