Search code examples
google-sheetsgoogle-finance

How to pivot googlefinance() horizontally?

In Google Sheets, is there a way to pivot the output of googlefinance() horizontally? Currently, it outputs prices/dates vertically.

Solution

  • Use TRANSPOSE(), 

    =TRANSPOSE(googlefinance())

    enter image description here

    is that what you where up to?