Ciasto piekarz
Reputation: 8277
Transpose google spread sheet row values to column in different sheet
I have a google spreadsheet that has Sheet1 (tab 1) column values I want to be row value in a column in sheet (tab 2)
So I wrote formula ={'Sheet1'!A2:A35} and it does give me column values from sheet value but the outputs to multiple row (vertically)
is it possible that the row values of column A in sheet 1 to become column values of a single row in sheet 2.
the reason why I want is because in sheet 2 they act has Header to columns.
Upvotes: 0
Views: 204
Answers (2)
Erik Tyler
Reputation: 9345
You actually include the answer in your own title. Use this:
=TRANSPOSE(Sheet1!A2:A35)
Upvotes: 1
Related Questions
- Combine and transpose
- Transpose column to row google app script
- Importing columns across two Google Sheets in same spreadsheet
- Transpose rows to column grouped by a column in Googles Sheets
- App Script, transposing data and appending rows
- I need to copy Data from Google Sheet 1 to a Row in Google Sheet2
- Query and transpose data in Google Sheets
- Sheets: Transpose Single Column to Multiple Rows
- transpose array in my sheet
- How to split and transpose results over 2 columns