Hey @Ciaran ,
Looks like a multi-row formula is what you're after, something like this should work:
STartsWith([Col A],"Title") THEN [Col A]
ELSE [Row-1:New Field]
In the config make sure you're setting it as a string field!
Please remember to accept as a solution if this works!