I want to importrange from Spreadsheet OLD with several tabs/sheets into Spreadsheet NEW. What i want to do is to import values from SheetA and Sheet B.
First column: vstack(importrange(SheetA!A5:A),importrange(SheetB!B5:B)
easy
The problem is here.
In second column, I would like to do something like if the row imported is from sheet A , then “Sheet A”, if the row imported is from sheet B, then “Sheet B”.