title: Update single field for rows grouped by name
body: <p><img src="https://i.stack.imgur.com/ndND9.png" alt="Sample Output"></p>
  
  <p>I need to update a SSN field with the same number for each person. Doesn't matter which SSN it is since they are invalid, just need them for unique identifiers in SSN format. This means either min or max number would be acceptable. Current table includes rows which could be grouped by multiple columns to ensure that each person is unique, such as first name, last name, address and patient number.</p>
  
  <p>How would I take one of John Doe's EmpID1 values and copy it to every one of his rows, then do the same for Jane Doe's multiple rows?</p>
  
  <p>Thanks!</p>