If you see the 'awaiting collection' message in a cell, similar to the example below, it means that you have a valid function in the cell, it is simple waiting for you to collect the data.

You can collect the data by clicking on the 'Collect Data' button in the upper right hand side of the sheet.

Once the query has run and the data has returned, you will be able to see the value in the cell, which previously had the 'awaiting collection' message.