title: Flattening mutliple Rows into a single row based on identifier
body: <p>I'm trying to get a result set (and eventually create a view) that will combine rows based on an identifier. Below is an example of what I have, and what I'm trying to achieve:</p>
  
  <p>Existing Data</p>
  
  <pre>
  
      /* +----+------+---------+------+-------------------+-------------------+ */
      /* | ID | GUID |  Name   | Age  |      Address      | Entry_Create_Date | */
      /* +----+------+---------+------+-------------------+-------------------+ */
      /* |  1 |  123 | Bob     | 42   | NULL              | 1/2/2018          | */
      /* |  1 |  245 | Bob     | 41   | 123 Muffin Lane   | 1/1/2018          | */
      /* |  1 |  356 | Bob     | NULL | NULL              | 1/3/2018          | */
      /* |  2 |  456 | Charles | 21   | 235 Sherbert Lane | 1/3/2018          | */
      /* +----+------+---------+------+-------------------+-------------------+ */
  
  </pre>
  
  <p>Desired output:</p>
  
  <pre>
  
      /* +----+---------+-----+-------------------+ */
      /* | ID |  Name   | Age |      Address      | */
      /* +----+---------+-----+-------------------+ */
      /* |  1 | Bob     |  42 | 123 Muffin Lane   | */
      /* |  2 | Charles |  21 | 235 Sherbert Lane | */
      /* +----+---------+-----+-------------------+ */
  
  </pre>
  
  <p>Results use the Entry_Create_Date to determine the latest record. Once that row is found, it uses that as the basis. If the values are NULL, it uses the values of the other rows with the same ID value to get the values from them. Precedence of column value is determined by the date it was created.</p>