AI Assistant
Help Center AI Assistant is now available
Got questions about Lark? Use our AI chat to find the answers.
00:00
Click and hold to drag
Got It
Try Now
Transpose rows and columns in Sheets

Transpose rows and columns in Sheets

1 min read
I. Intro
You can transpose rows or columns to rotate data from vertical to horizontal or vice versa.
Note: This feature is not supported on the mobile app.
II. Steps
From the toolbar menu
Copy the data you want to transpose, click Menu on the left side of the top toolbar, and click Edit > Paste special > Transpose.
250px|700px|reset
From the right-click menu
Copy the data you want to transpose, right-click a cell, then click Paste special > Transpose.
250px|700px|reset
III. Related
IV. FAQs
Can I transpose rows and columns on the mobile app?
No.
Can I transpose rows and columns for data copied from a cell with a formula?
Yes, the referenced area of the formula will change accordingly after you transpose rows and columns.
Written by: Lark Help Center
Updated on 2024-11-25
How satisfied are you with this content?
Thank you for your feedback!
Need more help? Please contact Support.
0
rangeDom
rangeDom
rangeDom