Google Sheets: How to replace text in column header?

google-sheets google-drive-api google-sheets-query
Guillaume Perrot picture Guillaume Perrot · Jan 16, 2013 · Viewed 52.6k times · Source

I have a query like this =QUERY(B2:C9; "select (C * 100 / B) - 100") in my Google Sheets. What is displayed as a column header is:

difference(quotient(product(100.0()))100.0()).

I want to put a human readable description there instead.

How can I achieve this?

Answer

AdamL picture AdamL · Jan 16, 2013

=QUERY(B2:C9;"select (C*100/B)-100 label (C*100/B)-100 'Value'")

https://developers.google.com/chart/interactive/docs/querylanguage#Label

Related questions

How to automatically import data from uploaded CSV or XLS file into Google Sheets

I have a legacy database system (not web accessible) on a server which generates CSV or XLS reports to a Google Drive folder. Currently, I am manually opening those files in Drive web interface and converting them to Google Sheets. …

Read More
How can I create a hyperlink in the middle of cell text?

In google spreadsheets, it is possible to add a hyperlink to a cell as: =hyperlink("www.google.com", "search the web") This will show the text search the web which will hyperlink to google. However, I am wondering: How can …

Read More
Getting Google Spreadsheet CSV into A Pandas Dataframe

I uploaded a file to Google spreadsheets (to make a publically accessible example IPython Notebook, with data) I was using the file in it's native form could be read into a Pandas Dataframe. So now I use the following code …

Read More