Just to note, for the answer that you marked as correct ... the second instance where col1=2 has col5 = 'ewqq' and not 'kjhg' as you specified. Eirikur's solution however gives the output that you are looking for. Also from your data, is col1 a key field? If so I would not insert the results back into your table for you would violate the key field.