How do I make the results span several cells? When I enter a function, I get a value to just one cell.

With the Supermetrics function (in older versions called "getData"), you can fetch large data sets with a single formula using the 'dimensions' parameter (for example, splitting visits by traffic source). Note that if you add dimensions to the query, the function has to be entered as an array formula, which covers a range of cells (as the results split by a dimension won't fit into a single cell).

To input an array formula in Excel: 

  1. Select a range of cells.
  2. Type the function to the formula bar.
  3. Press CTRL, SHIFT and ENTER simultaneously.

Note that Google Sheets does this automatically, these instructions are only needed when using the functions in Excel.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.