The Google Sheets formula below is located in column A1 of my Google Sheet. This formula creates data in column A & B. I need to transpose this data into 1 row
=GOOGLEFINANCE(A2,"price",TODAY()-30,TODAY())
=TRANSPOSE(GOOGLEFINANCE(A2,"price",TODAY()-30,TODAY()))
The transpose formula successfully transposes the data in the 2 columns to 2 rows, as it should. My question is, will there be a way to transpose two columns of data into 1 single row - I have searched around for a solution for Google Sheets without any Luck.
you can use famous "double query smush" like:
=QUERY(TRANSPOSE(QUERY(TRANSPOSE(GOOGLEFINANCE(A2, "price", TODAY()-30, TODAY())),,999^99)),,999^99)