title: Excel concatenate by matching ID
body: <p>I have a table which is an export of a database of records of information relating to user accounts on my site. My end result of this is to move the information from an old database structure, into an import function, so I need to get the format correct in my new table before I begin the import.</p>
  
  <p>This is what it looks like to start with, albeit a simplified version</p>
  
  <p><img src="https://i.stack.imgur.com/DC97x.png" alt="Opening Database"></p>
  
  <p>And what I'm trying to do is check any data that matches in the UserID column, and put those values into the Value column (or a new column if thats easier to achieve)</p>
  
  <p>So this is how I would want it to look</p>
  
  <p><img src="https://i.stack.imgur.com/qWvfc.png" alt="Concatenated values"></p>
  
  <p>Assuming this isn't something that could be done through Excels formatting, so I assume it would need to be a custom function, but I don't know enough VB to write it myself.</p>
  
  <p>*Before anyone suggests, I'm stuck with this version of the export, I can't do a different database export as the client no longer has the db</p>