Merge two rows (having a different cell value) into a single row; overwrite values for text

Hello,   I want to merge rows when duplicate "Task" value is found; and overwrite text from one "Response" value to another cellwhen Scaled Value is "-1.00". For example, see below two rows: In...