Reputation: 145
I would like to query a range A1:B3 with two columns, adding an initial third column with a character.
This is the data:
These are my query attempts:
=QUERY($A$1:$B$3,"SELECT '-', A, B")
=QUERY($A$1:$B$3,"SELECT '-', A, B",0)
This is the output
Would love a solution that looks like this:
Thanks for considering my query.
Kent
Upvotes: 1
Views: 151
Reputation: 27262
Maybe add a second query where you use an offset ?
=QUERY(QUERY($A$1:$B$3,"SELECT '-', A, B",0), "offset 1")
Upvotes: 1