Complicated formula

I have a list of data that is grouped by Session ID. For each search session, where you see Activity Type =Viewed Page and then see the Activity Type=Text Searched, take the Activity Additional Detail (URL) from the last Viewed Page in that session and apply it to the Activity Additional Detail (URL) for the Text Searched (which is blank).