--- title: Larilyn's Tip of the Week:  Microsoft Excel - Transposing Rows &  Columns description: Cell Data to Separate Columns image: https://www.inmotionnet.com/hubfs/CoolGeels-654x280.jpg --- [Skip to content](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0#main-content) [Contact us](https://www.inmotionnet.com/contact) ![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png) - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) Open main navigation Close main navigation - [Home](https://www.inmotionnet.com/) - [Contact](https://www.inmotionnet.com/contact) - Client Tools Show submenu for Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Contact us](https://www.inmotionnet.com/contact) Mar 31, 2022 4:30:00 AM # Larilyn's Tip of the Week:  Microsoft Excel - Transposing Rows &  Columns [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Share: [facebook-f icon](http://www.facebook.com/share.php?u=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0) [linkedin-in icon](http://www.linkedin.com/shareArticle?mini=true&url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0) [Twitter icon](https://twitter.com/intent/tweet?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0) [pinterest-p icon](http://pinterest.com/pin/create/link/?url=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0) [envelope icon](mailto:?body=https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0) To double down on my nerdiness, let me let you all in on a little secret - I love, and I mean LOVE working in Excel spreadsheets.  I don't know what it is about it.....something about all the data and organizing it.  Really, I should admit that I'm an organizing geek, not an Excel geek, but you know....not mutually exclusive. ![CoolGeels-654x280](https://www.inmotionnet.com/hs-fs/hubfs/CoolGeels-654x280.jpg?width=654&name=CoolGeels-654x280.jpg) Anyway.....so, sometimes when I start working on a new project and I decide to use Excel to organize things, I may get so excited to do so that I don't think things through.  I start labeling columns and putting things in rows and I get a lot done really quickly before I realize....wait!  I don't want this information to be in a row.  I want it to be in a column! And I get a little sad, thinking I've wasted precious organizing time. ![wasted-time-e1494629506798](https://www.inmotionnet.com/hs-fs/hubfs/wasted-time-e1494629506798.webp?width=675&name=wasted-time-e1494629506798.webp) Until I realize there is a super simple fix for this!  Don't you love when I come to you guys with super simple fixes???  I know I do.   ![yay](https://www.inmotionnet.com/hs-fs/hubfs/yay.webp?width=400&name=yay.webp) You'll start by highlighting the data you want to move around and copy it.  You can click CTLR+C, you can right click and hit Copy.  You can use the copy icon.  Whichever way you so desire.  ![b4a6e34553aa6d0f93a7c045e4ead998](https://www.inmotionnet.com/hs-fs/hubfs/b4a6e34553aa6d0f93a7c045e4ead998.jpeg?width=474&name=b4a6e34553aa6d0f93a7c045e4ead998.jpeg) Then you want to select the cell where you want to put the data.  Once selected, you want to click on the drop down menu under Paste (make sure you are on the Home section of the menu).  In the drop down, select Paste Special. ![paste special](https://www.inmotionnet.com/hs-fs/hubfs/paste%20special.jpg?width=663&name=paste%20special.jpg) This will open up a new window - you want to make sure you click the box that says Transpose and then click okay. ![transpose](https://www.inmotionnet.com/hs-fs/hubfs/transpose.jpg?width=707&name=transpose.jpg) And voila!  Rows and columns have been swapped!  You can keep both sets of data or delete the one you don't want.  Up to you! ![transposed](https://www.inmotionnet.com/hs-fs/hubfs/transposed.jpg?width=714&name=transposed.jpg) But whatever you do, make sure to save your work!  No one likes to lose their precious organized data! ![flat,750x1000,075,f.u6](https://www.inmotionnet.com/hs-fs/hubfs/flat%2c750x1000%2c075%2cf.u6.jpg?width=290&name=flat%2c750x1000%2c075%2cf.u6.jpg)   [Excel](https://www.inmotionnet.com/blog/tag/excel) ## Related posts [![](https://www.inmotionnet.com/hs-fs/hubfs/1c7e9681-5cd0-4ab3-8b47-f4220f046c0d_text.gif?height=200&name=1c7e9681-5cd0-4ab3-8b47-f4220f046c0d_text.gif)](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Excel](https://www.inmotionnet.com/blog/tag/excel) ## [Larilyn's Tip of the Week:  Steps Recorder](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Apr 28, 2022 4:00:00 AM The time has come to switch gears. After many weeks of Excel tips, we are moving on! I'm taking a... [Read more](https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0-0-0) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Consent Phishing](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Aug 18, 2021 9:30:00 PM When it comes to technology, there are two things that are certain: [Read more](https://www.inmotionnet.com/blog/2021/08/larilyns-tip-of-the-week-consent-phishing) [Uncategorized](https://www.inmotionnet.com/blog/tag/uncategorized) ## [Larilyn’s Tip of the Week: Windows 10](https://www.inmotionnet.com/blog/2018/01/272) [Larilyn Holt](https://www.inmotionnet.com/blog/author/larilyn-holt) Jan 11, 2018 12:46:36 AM Guys. Let’s get serious for a second. [Read more](https://www.inmotionnet.com/blog/2018/01/272) [![](https://www.inmotionnet.com/hs-fs/hubfs/InMotionLogoNEW_RGB%20copy.png?width=600&height=350&name=InMotionLogoNEW_RGB%20copy.png)](https://inmotionnet.com) 24930 Washington Ave Unit #157 Murrieta, CA  92564 (951) 894-8809 This is a search field with an auto-suggest feature attached. - There are no suggestions because the search field is empty. - [Home](https://www.inmotionnet.com) - [Blog](https://www.inmotionnet.com/blog) - [Contact](https://www.inmotionnet.com/contact) - Client Tools - [Client Portal](https://na.myconnectwise.net/v4_6_release/services/system_io/CustomerPortal/Portal.html?company=inmotionnets) - [Payment Portal](https://inmtn.connectboosterportal.com/) - [Privacy](https://www.inmotionnet.com/privacy-policy) - [Terms](https://www.inmotionnet.com/terms-of-service) --- [linkedin-in icon](https://www.linkedin.com/company/in-motion-networks-corporation/) [Twitter icon](https://twitter.com/InMotionNet/) [facebook-f icon](https://www.facebook.com/inmotionnet/) Copyright © 2026, In Motion Networks Corporation ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Larilyn Holt", "url" : "https://www.inmotionnet.com/blog/author/larilyn-holt" }, "dateModified" : "2022-03-31T11:30:00.519Z", "datePublished" : "2022-03-31T11:30:00.000Z", "headline" : "Larilyn's Tip of the Week:  Microsoft Excel - Transposing Rows &  Columns", "image" : [ "https://www.inmotionnet.com/hubfs/CoolGeels-654x280.jpg" ], "mainEntityOfPage" : { "@id" : "https://www.inmotionnet.com/blog/larilyns-tip-of-the-week-microsoft-excel-cell-data-to-separate-columns-0-0-0", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.inmotionnet.com/hubfs/InMotionLogoNEW_RGB%20copy.png" }, "name" : "In Motion Networks" } } ```