Transpose 2 Columns into 1 Row, Google Sheets

1
votes

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.

1
google-sheetstransposegoogle-sheets-formulagoogle-sheets-querygoogle-finance

1 Answers

0
votes

you can use famous "double query smush" like:

=QUERY(TRANSPOSE(QUERY(TRANSPOSE(GOOGLEFINANCE(A2, "price", TODAY()-30, TODAY())),,999^99)),,999^99)