SQL that copies and pastes data in a database that changes

Transact-SQL
1

Good Morning,

I have programmed a SQL coding that copy "z" data under the "a" data but the number "a" rows can change (It finishes row number 16 in my example below but it can finish row number 25)
I have added below the coding that I had programed
Can you change my coding in order to include the change that I want to carry out ?

Thanks for your help

Capture d’écran 2022-06-13 à 00.10.52
Capture d’écran 2022-06-13 à 00.10.522802×1232 266 KB

function azerty() {

  • var spreadsheet = SpreadsheetApp.getActive();*
  • spreadsheet.getRange('L5').activate();*
  • var currentCell = spreadsheet.getCurrentCell();*
  • spreadsheet.getSelection().getNextDataRange(SpreadsheetApp.Direction.NEXT).activate();*
  • currentCell.activateAsCurrentCell();*
  • currentCell = spreadsheet.getCurrentCell();*
  • spreadsheet.getSelection().getNextDataRange(SpreadsheetApp.Direction.DOWN).activate();*
  • currentCell.activateAsCurrentCell();*
  • spreadsheet.getRange('D11').activate();*
  • spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();*
  • spreadsheet.getRange('L5:Q10').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);*
    };