Copy cells from a table to another table with conditions.

You can try the script below. I show that it is working with the file you provided:

function main(workbook: ExcelScript.Workbook) {
let inputTbl = workbook.getTable("Table1")
let outputTbl = workbook.getTable("Table3")

let nameCol = inputTbl.getColumnByName("Name").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let nationCol = inputTbl.getColumnByName("Write your nacionality.").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let cityCol = inputTbl.getColumnByName("Choose you city.").getRangeBetweenHeaderAndTotal().getValues() as string[][]
let ageCol = inputTbl.getColumnByName("Write your age.").getRangeBetweenHeaderAndTotal().getValues() as string[][]

let inputVals = inputTbl.getRangeBetweenHeaderAndTotal().getValues() as string[][]

let inputRowCount = inputTbl.getRangeBetweenHeaderAndTotal().getRowCount()
let inputColCount = inputTbl.getRangeBetweenHeaderAndTotal().getColumnCount()
let tempArr: string[][] = []

for (let i = 0; i < inputRowCount; i++) {
for (let j = 0; j < inputColCount; j++) {
if (inputVals[i][j] === "Yes") {
let finding = inputVals[i][j + 1]
let temp: string[] = [nameCol[i][0], finding, nationCol[i][0], cityCol[i][0], ageCol[i][0]]
tempArr.push(temp)
}
}
}

outputTbl.addRows(-1,tempArr)

}