{"id":33717,"date":"2023-12-29T04:29:53","date_gmt":"2023-12-29T03:29:53","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33717"},"modified":"2024-03-15T22:42:15","modified_gmt":"2024-03-15T21:42:15","slug":"transpose-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-in-excel\/","title":{"rendered":"How to Transpose in Excel &#8211; 3 Useful Methods"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33769 size-large\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1-1024x576.png\" alt=\"Transpose in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a> has a plethora of features that are useful for data analysis and manipulation. One such feature that is often used is <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/lookup\/transpose\/\" target=\"_blank\" rel=\"noopener\"><strong>TRANSPOSE<\/strong><\/a> in Excel.<\/p>\n<p>Transposing data refers to rearranging the orientation of your data i.e. switching the rows to columns and vice versa. This can be a handy tool for reorganizing information to better suit your analysis, reporting, or presentation needs.<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>Method 1 &#8211; Paste Special<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Method 2 &#8211; TRANSPOSE function<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Method 3 &#8211; Power Query<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us look at each of these methods.<\/p>\n<h3>Download the Excel Workbook below to follow along and understand How to Transpose in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Transpose-in-Excel.xlsx<\/span><\/a><\/h3>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-in-excel\/#Method_1_%E2%80%93_Paste_Special\" title=\"Method 1 &#8211; Paste Special\">Method 1 &#8211; Paste Special<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-in-excel\/#Method_2_%E2%80%93_TRANSPOSE_Function\" title=\"Method 2 &#8211; TRANSPOSE Function\">Method 2 &#8211; TRANSPOSE Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-in-excel\/#Method_3_%E2%80%93_Power_Query\" title=\"Method 3 &#8211; Power Query\">Method 3 &#8211; Power Query<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Paste_Special\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Method 1 &#8211; Paste Special<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can easily transpose data in Excel using the &#8220;<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/turn-text-to-values-with-excel-paste-special-values\/\" target=\"_blank\" rel=\"noopener\"><strong>Paste Special<\/strong><\/a>&#8221; option. Below is the sales data where &#8211;<\/p>\n<ul>\n<li>The rows represent different smartphones (Apple, Samsung, OnePlus, Google).<\/li>\n<li>The columns represent different months (January, February, March).<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33741 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-1.png\" alt=\"Transpose in Excel\" width=\"479\" height=\"324\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-1.png 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-1-300x203.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/a><\/p>\n<p>Now, you want to <strong>reverse<\/strong> this i.e. you want rows to represent months and columns to represent smartphones. Follow the steps below to learn how to <strong>transpose and convert rows to columns and columns to rows<\/strong> &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span>Highlight<\/strong> the sales data table and go to <strong>Home &gt; Copy<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33742 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-2.png\" alt=\"Transpose in Excel\" width=\"788\" height=\"553\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-2.png 788w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-2-300x211.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-2-768x539.png 768w\" sizes=\"(max-width: 788px) 100vw, 788px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Move to the <strong>cell where you intend to place the transposed data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33743 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png\" alt=\"Transpose in Excel\" width=\"999\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png 999w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3-300x171.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3-768x437.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/a><\/p>\n<p><strong>STEP 3: <\/strong>Go to <strong>Home &gt; Paste &gt; <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/paste-special-a-values-multiplier-in-excel\/\" target=\"_blank\" rel=\"noopener\">Paste Special<\/a><\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33744 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-4.png\" alt=\"Transpose in Excel\" width=\"787\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-4.png 787w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-4-300x209.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-4-768x534.png 768w\" sizes=\"(max-width: 787px) 100vw, 787px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>In the Paste Special dialog box, select <strong>Transpose<\/strong> and Click <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33745 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-5.png\" alt=\"Transpose in Excel\" width=\"546\" height=\"412\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-5.png 546w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-5-300x226.png 300w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/a><\/p>\n<p>The transposed data will now be pasted in cell G1.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33746 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6.png\" alt=\"Transpose in Excel\" width=\"1486\" height=\"310\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6.png 1486w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6-300x63.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6-1024x214.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-6-768x160.png 768w\" sizes=\"(max-width: 1486px) 100vw, 1486px\" \/><\/a><\/p>\n<p>This method is quick and easy but is best suited for smaller datasets. It is useful when you do not want the transposed data to be linked to the original data.<\/p>\n<h2><\/h2>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_TRANSPOSE_Function\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">Method 2 &#8211; TRANSPOSE Function<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the <strong>previous method, the transposed data remains static<\/strong> i.e. any change you make in the original data will not affect the transposed data. If you use the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/transpose-formula-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>TRANSPOSE<\/strong><\/a> function you can <strong>link the original data with the transposed data<\/strong>.<\/p>\n<p>Follow the steps below to learn how to use the TRANSPOSE function in Excel &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>Go to the <strong>cell where you intend to place the transposed data<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33743 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png\" alt=\"Transpose in Excel\" width=\"999\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3.png 999w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3-300x171.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-3-768x437.png 768w\" sizes=\"(max-width: 999px) 100vw, 999px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Enter the TRANSPOSE function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33747 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-7.png\" alt=\"Transpose in Excel\" width=\"922\" height=\"381\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-7.png 922w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-7-300x124.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-7-768x317.png 768w\" sizes=\"(max-width: 922px) 100vw, 922px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Enter the argument i.e. range. Here, it is A1:E11.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33748 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-8.png\" alt=\"Transpose in Excel\" width=\"925\" height=\"384\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-8.png 925w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-8-300x125.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-8-768x319.png 768w\" sizes=\"(max-width: 925px) 100vw, 925px\" \/><\/a><\/p>\n<p>Your data has been transposed correctly.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33749 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9.png\" alt=\"Transpose in Excel\" width=\"1482\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9.png 1482w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9-300x78.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9-1024x265.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-9-768x198.png 768w\" sizes=\"(max-width: 1482px) 100vw, 1482px\" \/><\/a><\/p>\n<p>This method is useful when you want the transposed data to update dynamically with changes in the original dataset. Suppose, you change the value for Xiaomi sales for January to 1500 in the original data (i.e. B5), the transposed data will also be changed (i.e. K2).<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33750 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10.png\" alt=\"Transpose in Excel\" width=\"1480\" height=\"317\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10.png 1480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10-300x64.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10-1024x219.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-10-768x164.png 768w\" sizes=\"(max-width: 1480px) 100vw, 1480px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_Power_Query\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">Method 3 &#8211; Power Query<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/power-query-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>Power Query<\/strong><\/a> is a powerful and flexible way to handle large datasets and can be used to transpose data easily. Here&#8217;s a step-by-step guide on how to transpose data using Power Query &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-shift-end-select-all-your-data-in-excel\/\" target=\"_blank\" rel=\"noopener\">Select the sales data<\/a><\/strong> and go to <strong>Data<\/strong> &gt; <strong>From Table\/Range.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33751 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-11.png\" alt=\"Transpose in Excel\" width=\"945\" height=\"547\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-11.png 945w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-11-300x174.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-11-768x445.png 768w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>In the dialog box, select <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33752 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-12.png\" alt=\"Transpose in Excel\" width=\"898\" height=\"470\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-12.png 898w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-12-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-12-768x402.png 768w\" sizes=\"(max-width: 898px) 100vw, 898px\" \/><\/a><\/p>\n<p>In the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-editor-in-power-query\/\" target=\"_blank\" rel=\"noopener\">Power Query Editor<\/a>, you&#8217;ll see a table representing your data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33753 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13.png\" alt=\"Transpose in Excel\" width=\"1463\" height=\"584\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13.png 1463w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13-1024x409.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-13-768x307.png 768w\" sizes=\"(max-width: 1463px) 100vw, 1463px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Go to <b>Transform <\/b>&gt; <strong>Use Headers as First Row<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33760 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20.png\" alt=\"Transpose in Excel\" width=\"1379\" height=\"543\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20.png 1379w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-300x118.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-1024x403.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-20-768x302.png 768w\" sizes=\"(max-width: 1379px) 100vw, 1379px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Go to <b>Transform <\/b>&gt; <strong>Transpose<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33754 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14.png\" alt=\"Transpose in Excel\" width=\"1258\" height=\"553\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14.png 1258w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14-300x132.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14-1024x450.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-14-768x338.png 768w\" sizes=\"(max-width: 1258px) 100vw, 1258px\" \/><\/a><\/p>\n<p>The rows will be converted to columns and columns will be converted to rows.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33755 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15.png\" alt=\"Transpose in Excel\" width=\"1582\" height=\"376\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15.png 1582w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15-300x71.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15-1024x243.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15-768x183.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-15-1536x365.png 1536w\" sizes=\"(max-width: 1582px) 100vw, 1582px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Go to <b>Transform <\/b>&gt; <strong>Use First Row as Headers<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33756 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16.png\" alt=\"Transpose in Excel\" width=\"1584\" height=\"393\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16.png 1584w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16-300x74.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16-1024x254.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16-768x191.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-16-1536x381.png 1536w\" sizes=\"(max-width: 1584px) 100vw, 1584px\" \/><\/a><\/p>\n<p>The first row will now become the header.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33757 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17.png\" alt=\"Transpose in Excel\" width=\"1570\" height=\"395\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17.png 1570w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17-300x75.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17-1024x258.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17-768x193.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-17-1536x386.png 1536w\" sizes=\"(max-width: 1570px) 100vw, 1570px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6: <\/span><\/strong>Go to <strong>Home<\/strong> &gt; <strong>Close &amp; Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33758 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18.png\" alt=\"Transpose in Excel\" width=\"1545\" height=\"407\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18.png 1545w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18-300x79.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18-1024x270.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18-768x202.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-18-1536x405.png 1536w\" sizes=\"(max-width: 1545px) 100vw, 1545px\" \/><\/a><\/p>\n<p>The transposed data will be displayed in the new worksheet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-33759 size-full\" title=\"Transpose in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-19.png\" alt=\"Transpose in Excel\" width=\"955\" height=\"284\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-19.png 955w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-19-300x89.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Transpose-in-Excel-19-768x228.png 768w\" sizes=\"(max-width: 955px) 100vw, 955px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>In conclusion, Excel&#8217;s <a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419f2e3-beab-4318-aae5-d0f862209744\" target=\"_blank\" rel=\"nofollow noopener\"><strong>TRANSPOSE<\/strong><\/a> feature is a valuable tool for data analysts and professionals working on data manipulation.<\/p>\n<p>This article has provided a comprehensive overview of three methods for transposing data in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a> &#8211; quick and straightforward Paste Special option, the dynamic TRANSPOSE function, and the powerful and flexible Power Query.<\/p>\n<p><span style=\"font-weight: 400;\">Learn more about Power Query with our <\/span><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\"><strong>50 Things You Can Do With Excel Power Query<\/strong><\/a><span style=\"font-weight: 400;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel has a plethora of features that are useful for data analysis and manipulation. One such feature that is often used is TRANSPOSE in Excel. Transposing data refers to rearranging the orientation of your data i.e. switching the rows to columns and vice versa. This can be a handy tool for reorganizing information to better [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33769,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,121,10,498],"tags":[1524,1522,1523],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33717"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33717"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33717\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33769"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33717"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}