{"id":4095,"date":"2018-11-19T11:30:36","date_gmt":"2018-11-19T16:30:36","guid":{"rendered":"http:\/\/lisa.rushworth.us\/?p=4095"},"modified":"2018-12-19T11:32:38","modified_gmt":"2018-12-19T16:32:38","slug":"did-you-know-excel-can-transpose-data","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=4095","title":{"rendered":"Did you know \u2026 Excel can transpose data?"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Have you ever gotten data where the column headers are along the left-hand side and each record is a column? I\u2019m sure there are people who prefer each record to be a column too, and they probably hate my data where the headers run along the top and each row is a record. Did you know Excel can swap between these two formats?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here I have a spreadsheet where each column is a record. Highlight and copy the records. Yes you can use ctrl-c to copy \u2026 but there\u2019s no way to make a screen-print of my keyboard actions.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"360\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/12\/Excel-TransposeData01-1024x360.png\" alt=\"\" class=\"wp-image-4096\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData01-1024x360.png 1024w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData01-300x105.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData01-768x270.png 768w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData01.png 1073w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click elsewhere \u2013 below the data you copied, on a new sheet, even a new spreadsheet. Right-click &amp; expand \u201cPaste Special\u201d \u2013 find the icon for <em>Transpose <\/em>and click it. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"957\" height=\"655\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/12\/Excel-TransposeData02.png\" alt=\"\" class=\"wp-image-4097\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData02.png 957w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData02-300x205.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData02-768x526.png 768w\" sizes=\"auto, (max-width: 957px) 100vw, 957px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Look \u2013 now each row is a record, just like I wanted. You can even delete the original data if you want \u2013 the pasted information will still be there.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"875\" height=\"454\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/12\/Excel-TransposeData03.png\" alt=\"\" class=\"wp-image-4098\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData03.png 875w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData03-300x156.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-TransposeData03-768x398.png 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Have you ever gotten data where the column headers are along the left-hand side and each record is a column? I\u2019m sure there are people who prefer each record to be a column too, and they probably hate my data where the headers run along the top and each row is a record. Did you &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[709,265],"class_list":["post-4095","post","type-post","status-publish","format-standard","hentry","category-office-365","tag-microsoft-excel","tag-office-365"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4095","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4095"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4095\/revisions"}],"predecessor-version":[{"id":4099,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4095\/revisions\/4099"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4095"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4095"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}