{"id":193,"date":"2017-01-26T11:00:18","date_gmt":"2017-01-26T17:00:18","guid":{"rendered":"http:\/\/www.iqaccountingsolutions.com\/blog\/?p=193"},"modified":"2017-02-14T11:35:50","modified_gmt":"2017-02-14T17:35:50","slug":"transpose-columns-and-rows-in-excel","status":"publish","type":"post","link":"https:\/\/www.iqaccountingsolutions.com\/blog\/transpose-columns-and-rows-in-excel\/","title":{"rendered":"TRANSPOSE COLUMNS AND ROWS IN EXCEL"},"content":{"rendered":"<p>Have you ever wanted to completely rearrange the data you have in Excel so that your rows become columns and your columns become rows? Maybe you receive data that&#8217;s not formatted the way you need it or maybe you just changed your mind about how you want a spreadsheet arranged. Either way, <em>Paste Special &#8211; Transpose<\/em> is your answer.<\/p>\n<p>All you have to do is highlight the cells you want to rearrange by selecting them with your mouse (or try clicking anywhere in the table and type <em>Ctrl+*<\/em> on your keyboard). Right-click the selection and choose <em>Copy<\/em>. Then right-click where you want to place the transposed data (anywhere outside of the already highlighted cells) choose <em>Paste Special<\/em>, then <em>Transpose<\/em>. The data will be pasted into the new locations with the former rows now in columns and the former columns in rows.<\/p>\n<p>If you select and copy entire columns and then try to transpose them you&#8217;ll get an error. That&#8217;s because the maximum number of rows in a worksheet exceeds the maximum number of columns. But you can select entire rows and transpose them if it&#8217;s easier than selecting the exact cells in your table.<br \/>\n<iframe loading=\"lazy\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/72UQMlCV8Bw?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p>This is tip was updated January 2017, originally posted November 2010.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever wanted to completely rearrange the data you have in Excel so that your rows become columns and your columns become rows? Maybe you receive data that&#8217;s not formatted the way you need it or maybe you just changed your mind about how you want a spreadsheet arranged. Either way, Paste Special &#8211; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/193"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":10,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":1052,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/193\/revisions\/1052"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}