Rotate Data in EXCEL | Sinokap IT Tech Sharing
Sinokap China IT Service KDB
EXCEL Tricks
Rotate
Your Data
If you have a worksheet with data in columns that you need to switch the orientation, don't waste time doing it manually. Here are three methods you can try to rotate data from columns to rows, or vice versa.
The video is reproduced from the network.
If any infringement, please contact us.
Sinokap IT always supports you with Professional IT Services in Shanghai, China.
Sinokap IT团队为您在中国提供专业的技术支持~
☞ A Static approach
Ctrl+C to copy the data >Right-Click the cell to paste > Paste Special > Transpose
☞ Transpose Function
=TRANSPOSE(arrays) with Ctrl+Shift+Enter
☞ Direct References
Fill Series Tool & Find and Replace
Past Review
Video Formats - Common Examples
Video Formats - Containers and Codecs
Get Ransomware Protection Tips
Sinokap公众号每日放送IT小技巧，让你的工作、学习、甚至是日常生活更加高效、便捷。
Sinokap China IT Service Team daily broadcasts Professional IT Support Tips and Tricks. We are engaged to bring you a variety of IT skills that can be widely used in your business work, study and daily life.
关注我们
Follow us
如果你想了解更多IT资讯和小诀窍~
If you would like to learn more IT related news and IT Trick Tips.
加入我们
Join us
如果你想变得更强，成为一名专业的工程师~
If you want to improve self-ability and grow into a skillful engineer.
联系我们
Contact us
如果你需要专业的IT服务支持需求~
If you need Professional IT Support and IT Services in Shanghai, China.