extract previous row data

Hi all, I am trying to extract data using string manipulation. Although there is a row that doesn't consist of any fix keyword but there is a fix keyword in the next row. How do I get this done using Utility-Collection Manipulation or is there any other alternate?