{"id":1143,"date":"2023-11-08T12:00:20","date_gmt":"2023-11-08T17:00:20","guid":{"rendered":"https:\/\/molecularsciences.org\/content\/?p=1143"},"modified":"2023-12-05T15:19:58","modified_gmt":"2023-12-05T20:19:58","slug":"how-to-transpose-data-in-excel","status":"publish","type":"post","link":"https:\/\/molecularsciences.org\/content\/how-to-transpose-data-in-excel\/","title":{"rendered":"How to transpose data in Excel"},"content":{"rendered":"\n<p>The following steps show how to transpose data in Excel. Transposition refers to switching between rows and columns. See the three step process below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"451\" src=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-1.png\" alt=\"\" class=\"wp-image-1260\" srcset=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-1.png 648w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-1-300x209.png 300w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure>\n\n\n\n<p>1 &#8211; copy a dataset<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"773\" height=\"417\" src=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-2-1.png\" alt=\"\" class=\"wp-image-1263\" srcset=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-2-1.png 773w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-2-1-300x162.png 300w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-2-1-768x414.png 768w\" sizes=\"auto, (max-width: 773px) 100vw, 773px\" \/><\/figure>\n\n\n\n<p>2 &#8211; before you paste, right-click on the first destination cell and click on Paste Special<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"892\" height=\"573\" src=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-3.png\" alt=\"\" class=\"wp-image-1264\" srcset=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-3.png 892w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-3-300x193.png 300w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-3-768x493.png 768w\" sizes=\"auto, (max-width: 892px) 100vw, 892px\" \/><\/figure>\n\n\n\n<p>3 &#8211; select Transpose<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"914\" height=\"485\" src=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-4.png\" alt=\"\" class=\"wp-image-1265\" srcset=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-4.png 914w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-4-300x159.png 300w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-4-768x408.png 768w\" sizes=\"auto, (max-width: 914px) 100vw, 914px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"943\" height=\"657\" src=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-5.png\" alt=\"\" class=\"wp-image-1266\" srcset=\"https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-5.png 943w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-5-300x209.png 300w, https:\/\/molecularsciences.org\/content\/wp-content\/uploads\/2023\/12\/transpose-5-768x535.png 768w\" sizes=\"auto, (max-width: 943px) 100vw, 943px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>The following steps show how to transpose data in Excel. Transposition refers to switching between rows and columns. See the three step process below: 1 &#8211; copy a dataset 2 &#8211; before you paste, right-click on the first destination cell and click on Paste Special 3 &#8211; select Transpose<\/p>\n","protected":false},"author":1,"featured_media":1216,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[207],"tags":[],"class_list":["post-1143","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/comments?post=1143"}],"version-history":[{"count":3,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1143\/revisions"}],"predecessor-version":[{"id":1267,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/posts\/1143\/revisions\/1267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media\/1216"}],"wp:attachment":[{"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/media?parent=1143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/categories?post=1143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/molecularsciences.org\/content\/wp-json\/wp\/v2\/tags?post=1143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}