This guide is part of the Google Docs series
1.
Auto fit column width in Google docs spreadsheets
2. Change a date in a Google doc spreadsheet cell
3. Change the hyperlink color in a docs document
4. Change the slide speed in Google Docs presentation
5. Convert Google docs spreadsheet into a PDF file
6. Convert Google docs spreadsheet into an Excel file
7. Freeze top row when scrolling in Google Docs
8. How to add a column to a google docs spreadsheet
9. How to add a URL to a Google doc document
10. How to add a URL to a Google doc spreadsheet
2. Change a date in a Google doc spreadsheet cell
3. Change the hyperlink color in a docs document
4. Change the slide speed in Google Docs presentation
5. Convert Google docs spreadsheet into a PDF file
6. Convert Google docs spreadsheet into an Excel file
7. Freeze top row when scrolling in Google Docs
8. How to add a column to a google docs spreadsheet
9. How to add a URL to a Google doc document
10. How to add a URL to a Google doc spreadsheet
Make: Google
Model / Product: Docs
Version: Spreadsheet
Objective / Info: How to convert a column into a row in Google Docs spreadsheet.
Model / Product: Docs
Version: Spreadsheet
Objective / Info: How to convert a column into a row in Google Docs spreadsheet.
1
Launch Google Docs spreadsheet by visiting google.com, click the "more" menu otpion and select "Documents"
2
Select "spreadsheet" from the menu.
3
Populate and select the cells that you want to convert.
4
Select the column where you want to display the set of data
5
Click "Insert" on the menu, then click "Function" , then "more".
6
Select the "Lookup" option on the left.
7
Select the "Transpose" option on the right.
8
Select the cells in the column that you want to convert into a row.
Note :
The cell to the right should update to show the cells that you are selecting.
9
Press the "Enter" key on your keyboard. All the data that was in the column should populate into a row.
10
This task should be complete. If it is not, review and repeat the steps.
comments powered by Disqus
Ask a question or provide an answer