title: Formula that retrieves the cell value of another cell the row below it
body: <p>I've got a dataset which has a blank row and a file name in the row below it repeating for the whole sheet multiple times. Each file name is different and what im wanting to capture in the currently blank row is the cell value of the cell below it i.e the filename with a formula.</p>
  <p>Im not very proficient in excel sheets but feel this is something simple?
  This provides me what i need but it is not dynamic.
  =&quot;FILENAME IS&quot; &amp; A2</p>
  <p>I need a formula i can copy across all the blank rows which will do something like =&quot;FILENAME IS&quot; &amp; A:ROW()+1</p>
  <p>Thanks in advance :)</p>