1
votes

Thanks in Advance,

I'm collecting Data from Google Forms into a spreadsheet and filtering the data by using a query. one of the form inputs, has a long description because its a question. I'm trying to change/rename it after the Query much like you can set a new value to an object key in JS

is it possible in sheets, cheers

Sheet

1
share a copy of your sheet with example of desired resultplayer0

1 Answers

2
votes

You can use:

=QUERY(A1:C5,"Select 'Online',B,C label 'Online' 'Where Did the leads come from'",1)

enter image description here