Use linq to join rows

have a look here: