title: Excel find IDs in List and append them comma separated
body: <p>I am trying to search an ID in a Column (which will have this ID possibly multiple times) and then take the next Column of the found ID and put the text in a field comma separated. I think this Image is showing it better than I can with my broken english.</p>
  
  <p>All this should happen automatically. With VBA or a Formula if possible.<a href="https://i.stack.imgur.com/dBwFs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dBwFs.png" alt="enter image description here"></a></p>
  
  <p>The left list should be translated to the right. Any clues on how to achieve something like this?</p>