Add "filler" column to Query in Google sheets

user_14442548 0
Viewed 67

I would like to query a range A1:B3 with two columns, adding an initial third column with a character.

This is the data:

enter image description here

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

enter image description here

Would love a solution that looks like this:

enter image description here

Thanks for considering my query.

Kent

google-sheets
1 Answers

Maybe add a second query where you use an offset ?

=QUERY(QUERY($A$1:$B$3,"SELECT '-', A, B",0), "offset 1")

enter image description here

user_38894230
Related