title: CONCATENATE in ArrayFormula's IF statement in Google Sheets not
body: <p><a href="https://stackoverflow.com/questions/19039665/make-google-spreadsheet-formula-repeat-infinitely">Make Google Spreadsheet Formula Repeat Infinitely</a> helped me to expand my formula indefinitely and other StackExchange results helped me get to here:</p>
  
  <p>=ARRAYFORMULA(IF((AF2:AF="")," ","L"&amp;ROW(F2:F)&amp;":AD"&amp;ROW(F2:F)))</p>
  
  <p>However, when I tell "L"&amp;ROW(F2:F)&amp;":AD"&amp;ROW(F2:F) to CONCATENATE, every row gives a results as if it was CONCATENATE(L2:AD2).</p>
  
  <p>I tried =ARRAYFORMULA(IF((AF2:AF="")," ",CONCATENATE("L"&amp;ROW(F2:F)&amp;":AD"&amp;ROW(F2:F)))) and =ARRAYFORMULA(IF((AF2:AF="")," ",CONCATENATE(INDIRECT("L"&amp;ROW(F2:F)&amp;":AD"&amp;ROW(F2:F))))) but neither are working.</p>
  
  <p>I am trying to get each row to CONCATENATE(L2:AD2) then CONCATENATE(L3:AD3) then L4:AD4 and so on.</p>
  
  <p>Any help is most appreciated.</p>