title: concatenate cells based on other range criterias
body: <p>I need to concatenate cells in Range "B" based on criteria for range "A" &amp; "C". Initially I was trying to code out using Arrays to store value but doesn't seem to work. </p>
  
  <p><strong>For example:</strong></p>
  
  <p>Criteria excel:</p>
  
  <p><a href="https://i.stack.imgur.com/BeZ8z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BeZ8z.png" alt="enter image description here"></a></p>
  
  <p>Outcome:</p>
  
  <p><a href="https://i.stack.imgur.com/4kzOX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4kzOX.png" alt="enter image description here"></a></p>
  
  <p>Based on the example, the outcome should be reflected with first criteria of range"C" (date) then follow by concatenated results(Range "B") based on second criteria range"A"</p>