title: Excel formula loop until condition
body: <p>I am concatenating every columns of the rows on excel sheet and I am already done with the concatenating of every columns. 
  My problem is I only need to concatenate the rows that does not contain letter T on column A starting row 3. <em>please see image below</em></p>
  
  <p><a href="https://i.stack.imgur.com/6U5wu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6U5wu.png" alt="enter image description here"></a></p>
  
  <p><em>sample formula</em></p>
  
  <blockquote>
    <p>=Sheet1!A3&amp;Sheet1!B3&amp;Sheet1!C3&amp;Sheet1!D3&amp;Sheet1!E3&amp;Sheet1!F3&amp;Sheet1!G3&amp;Sheet1!H3&amp;Sheet1!I3&amp;Sheet1!J3&amp;Sheet1!K3&amp;Sheet1!L3&amp;Sheet1!M3&amp;Sheet1!N3&amp;Sheet1</p>
  </blockquote>
  
  <p>on that image, you can see the result below of the concatenated columns from the above details, but not all the time the rows to be concatenated there has the same number(like on the above image that has only 3 rows to be computed), do you know some code or formula for this matter?</p>