title: joining all cell value between ascending range
body: <p>I am trying to figure out how to join every cell (normal text) in the D column between the range I have set up in the A column. While searching I came across variations of the concatenate, textjoin and other functions but could not seem to find the right option.</p>
  
  <p>There are around 8000 values in my file(ID value in column A) so it should be automatically filled and not manual. since it would take weeks to complete...</p>
  
  <p>i've added a visual representation of the problem</p>
  
  <p><a href="https://i.stack.imgur.com/23lkj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/23lkj.png" alt="enter image description here"></a></p>
  
  <p>The solution would be to have all cells selected in column D between the value '1' and '2' in column A and joined togheter in the E column in the row where the the cell in the A column isn't blank.
  I hope someone can help me with this problem.</p>