Looking for a way to populate an additional column in possibly a
QUERY function. The extra column will only have as many rows as the first set of data. Example being my data is Sheet1!A:A
and then on Sheet2 using something like
=(query(A:A, "Select A"),[extra colB magic for 'TRUE']) I'd like the output to be
I am aware that it only takes 15 seconds to populate ColB to TRUE, but I'm looking to avoid the manual touch of doing this.
Thanks in advance