{"id":6242,"date":"2023-10-30T04:20:49","date_gmt":"2023-10-30T04:20:49","guid":{"rendered":"https:\/\/www.repairmsexcel.com\/blog\/?p=6242"},"modified":"2023-11-02T07:25:36","modified_gmt":"2023-11-02T07:25:36","slug":"transpose-data-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel","title":{"rendered":"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide"},"content":{"rendered":"<div class=\"1898181a2aebca931198b7f41678d855\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Very often users have to face a situation where their data in the MS Excel spreadsheet isn\u2019t in the correct format for presentation or analysis. Thus, if you are in the same situation, you are not alone. Transposing data in the Excel can be the best solution to this issue. In this write-up, I will discuss the art of data transposition and other crucial info including the step-by-step methods on <strong>how to transpose data in Excel<\/strong>.<!--more--><\/p>\n<p>So, let&#8217;s get started&#8230;<\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To fix corrupted Excel files, we recommend this tool:<\/strong><\/p><p style='font-size: 17px;'>This software will prevent Excel workbook data such as BI data, financial reports & other analytical information from corruption and data loss. With this software you can rebuild corrupt Excel files and restore every single visual representation & dataset to its original, intact state in 3 easy steps:<\/p><div><ol style='font-size: 17px; margin-top: 4px;'><li><strong><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' target='_blank'>Try Excel File Repair Tool<\/a><\/strong> rated <i>Excellent<\/i> by Softpedia, Softonic & CNET.<\/li><li>Select the corrupt Excel file (XLS, XLSX) & click <b>Repair<\/b> to initiate the repair process.<\/li><li>Preview the repaired files and click <b>Save File<\/b> to save the files at desired location.<\/li><\/ol><\/div><\/div><\/div><br>\n<h3 style=\"text-align: left;\"><strong>Quick Navigation:<\/strong><\/h3>\n<p><strong><a href=\"#part1\">What is Data Transposition in MS Excel?<\/a><\/strong><\/p>\n<p><strong><a href=\"#part2\">Benefits of Data Transposition <\/a><\/strong><\/p>\n<p><strong><a href=\"#part3\">How to Transpose Data in MS Excel?<\/a><\/strong><\/p>\n<ul>\n<li><strong><a href=\"#s1\">Using Transpose Excel Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Using Paste Special Feature<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Switch Columns and Rows in Excel with INDEX Function<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Use Power Query<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">With Direct References<\/a><\/strong><\/li>\n<\/ul>\n<p><a name=\"part1\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>What is Data Transposition in MS Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Transposing data in Excel is a useful way to switch the orientation of data in an array. This means the data in vertical portions are shifted to a horizontal format in the spreadsheet without disrupting any facts or figures. For a better understanding, check out the below image:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7288 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/How-to-Transpose-Data-in-Excel.png\" alt=\"How to Transpose Data in Excel\" width=\"600\" height=\"388\" \/><\/p>\n<p style=\"text-align: justify;\">Consequently, in Microsoft Excel, there is a <strong>TRANSPOSE<\/strong> feature available that allows the users to rotate data from rows to columns or vice versa. It can save your precious time, effort and even make your data more organized.<\/p>\n<p style=\"text-align: justify;\">Besides, transposing the Excel data process can be done with other useful techniques that are mentioned in one of the below sections.<\/p>\n<p><a name=\"part2\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Benefits of Data Transposition <\/strong><\/h2>\n<p>Well, there are various advantages of transposing data:<\/p>\n<ul>\n<li>It simplifies the data analysis.<\/li>\n<li>It helps to make your spreadsheet data more organized &amp; presentable.<\/li>\n<li>It also simplifies the formation of charts &amp; graphs.<\/li>\n<\/ul>\n<p><a name=\"part3\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>How to Transpose Data in Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">If you intend to transpose data in Excel manually, this would consume a massive time, all it requires is a few simple tricks to perform this process.<\/p>\n<p><a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 1- Using Transpose Excel Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">As already said, the <strong>TRANSPOSE<\/strong> is an excellent function available in MS Excel that can assist you in transposing cells with less effort. Here are the steps to look forward &amp; complete your job.<\/p>\n<ul>\n<li>Choose the range of cells that you intend to transpose<\/li>\n<li>Since Transpose is an array-based formula, it\u2019s important to select the exact number of cells<\/li>\n<li>Assuming you have chosen <strong>4&#215;5<\/strong> as per your table range, where <strong>4 rows and 5 columns<\/strong> are highlighted. In the next step, you should choose<strong> 5&#215;4<\/strong> for setting the transposed data.<\/li>\n<li>Type the formula \u201c<strong>=TRANSPOSE(A1:C1)\u201d<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7289 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/transpose-function.png-1.png\" alt=\"Using Transpose Excel Function\" width=\"604\" height=\"167\" \/><\/p>\n<ul>\n<li>Press<strong> Ctrl+Shift+Enter<\/strong> to execute the formula<\/li>\n<li>This is done to ensure that the result would be an array of data instead of a sole cell<\/li>\n<li>Wait for the data to be transposed next up.<\/li>\n<\/ul>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/underused-excel-functions\">7 Most Underrated Excel Functions You Must Try<\/a><\/strong><\/p><\/blockquote>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 2- How to Transpose Data in Excel Using Paste Special Feature<\/strong><\/h3>\n<p style=\"text-align: justify;\">This feature allows you to make sure the format of the content is under your control. Thus, this feature can be used in copying the real content and even past the transposed one. Let\u2019s check how it is done,<\/p>\n<ul>\n<li>First,\u00a0<strong>choose the range<\/strong> you are looking to transpose.<\/li>\n<li>Copy the <strong>data range\u00a0<\/strong>by pressing <strong>Copy<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7290 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/paste-special-1.png\" alt=\"Using Paste Special Feature\" width=\"604\" height=\"407\" \/><\/p>\n<ul>\n<li>While doing so, traverse from the top-left of the target range of the same sheet<\/li>\n<li>Press <strong>Ctrl+Alt+V<\/strong> to access the same<strong> Paste Special<\/strong> option &gt;&gt; Check the <strong>Transpose<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6243\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/check-transpose.png\" alt=\"\" width=\"398\" height=\"330\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/check-transpose.png 398w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/check-transpose-300x249.png 300w\" sizes=\"auto, (max-width: 398px) 100vw, 398px\" \/><\/p>\n<ul>\n<li>Finally, Click <strong>OK<\/strong>.<\/li>\n<\/ul>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 3- How to Switch Columns and Rows in Excel with INDEX Function<\/strong><\/h3>\n<p style=\"text-align: justify;\">Another versatile function that can help you to get your job done is <strong>INDEX<\/strong> function. It is one of the Excel Lookup and Reference functions that returns a value or the reference to a value from within a table or range. You can even apply this feature to transpose Excel data.<\/p>\n<p>Here\u2019s how you can use this function:<\/p>\n<ul>\n<li style=\"text-align: left;\">Select the range where you need the transposed data to appear.<\/li>\n<li style=\"text-align: left;\">Next, type <strong>=INDEX(<\/strong>.<\/li>\n<li style=\"text-align: left;\">Choose the information you need to transpose.<\/li>\n<li style=\"text-align: left;\">After that, close a formula with <strong>,,2,1)<\/strong> for row-to-column transposition &amp; <strong>,,1,2)<\/strong> for column-to-row transposition.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7291 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Figure-1-Using-Excel-INDEX-function-1.png\" alt=\"How to Switch Columns and Rows in Excel\" width=\"622\" height=\"327\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Figure-1-Using-Excel-INDEX-function-1.png 808w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Figure-1-Using-Excel-INDEX-function-1-768x404.png 768w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Lastly, hit <strong>Enter<\/strong> to authorize the formula.<\/li>\n<\/ul>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 4- Use Power Query<\/strong><\/h3>\n<p style=\"text-align: justify;\">Using this method, it is possible to get repeated data from a similar source and use the technique to transpose. Here is how you <strong>transpose data in Excel, <\/strong>using Power Query,<\/p>\n<ul style=\"text-align: justify;\">\n<li>Firstly we assume you open <strong>data<\/strong> inside an Excel table. This can help you import the data into a power query and allow the process of transposing.<\/li>\n<li>Choose the range you want to transpose<\/li>\n<li>Go to the <strong>Data tab<\/strong> option<\/li>\n<li>On<strong> Get &amp; Transform Data<\/strong> option<\/li>\n<li>Under the \u201c<strong>From Table<\/strong>\u201d, click to open the <strong>Query<\/strong> or <strong>Power Query Editor.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-7292 size-full\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Transpose-Data-in-Excel-from-table.png\" alt=\"How to Transpose Data in Excel\" width=\"355\" height=\"126\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Within the editor, visit the <strong>Transformation option<\/strong> and choose the <strong>Table Section<\/strong>. Follow this up with <strong>First Row as Headers.<\/strong> Follow this up with <strong>Use Headers as the First Row<\/strong> option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7294 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Power-Query-2.png\" alt=\"Use Power Query\" width=\"522\" height=\"241\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Tap on the<strong> Transpose<\/strong> option and can be found in the same section<\/li>\n<li>This would transpose the selected Data range<\/li>\n<li>Choose the option \u201c<strong>Use First Row as Headers\u201d<\/strong><\/li>\n<li>This ensures to make the first row of transposed data is a header<\/li>\n<li>Tap on the <strong>File tab<\/strong> and choose <strong>Close &amp; Load<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7295 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/Use-Power-Query-2.png\" alt=\"Use Power Query\" width=\"634\" height=\"315\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Check if the entire process of transposing is successful or not. If not, try the next method.<\/li>\n<\/ul>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>Method 5- Transpose Excel Data with Direct References<\/strong><\/h3>\n<p style=\"text-align: justify;\">You can also use direct references to transpose Excel data. This technique allows you to find &amp; replace the reference with the data you need to display.<\/p>\n<p style=\"text-align: justify;\">Follow the below steps to do so:<\/p>\n<ul>\n<li>Click on the <strong>empty cell<\/strong>, then type reference &gt;&gt; the location of the initial cell you need to transpose. In this situation, I\u2019ll use the &#8211; <strong>raA2<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7297 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/pasted-image-0.png\" alt=\"Transpose Excel Data with Direct References\" width=\"688\" height=\"291\" \/><\/p>\n<p>Just below raA2, you have to type raB2.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7298 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/pasted-image-0-1.png\" alt=\"Transpose Excel Data with Direct References\" width=\"694\" height=\"342\" \/><\/p>\n<ul>\n<li>Now, highlight both the cells &amp; drag highlighted range out via clicking &amp; dragging a green box at the bottom-right of your selection.<\/li>\n<li>After that, press <strong>Ctrl + H <\/strong>to open \u201c<strong>Find and Replace.<\/strong>\u201d. Then click on <strong>Replace<\/strong> option &gt;&gt; in a \u201c<strong>Find what<\/strong>\u201d field, you need to type a selected prefix, \u201c<strong>ra<\/strong>\u201d (without quotes), &gt;&gt; then <strong>\u201c=\u201d<\/strong> (without quotes) in a \u201c<strong>Replace with<\/strong>\u201d field.<\/li>\n<li>At last, click on \u201c<strong>Replace all<\/strong>.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-7299 aligncenter\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/pasted-image-0-2.png\" alt=\"Transpose Excel Data with Direct References\" width=\"962\" height=\"287\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/pasted-image-0-2.png 1271w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2022\/06\/pasted-image-0-2-768x229.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/p>\n<p>Now, the number of certain cells has the mandatory information.<\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <\/strong><strong><a href=\"https:\/\/www.repairmsexcel.com\/blog\/use-excel-iserror-function\">How To Use Excel ISERROR Function?<\/a><\/strong><\/p><\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Related FAQs:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Main Purpose of Data Transposition in Excel? <\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tThe main purpose of data transposition in Excel is to rearrange the data from columns to rows or vice versa and make it more appropriate for analysis or presentation.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>What Is the Shortcut for Transpose in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>Ctrl + Alt + V<\/strong> is a shortcut for transpose in Excel.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Can I Undo a Data Transposition in Excel? <\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYes, you can undo a data transposition in by copying original data &amp; pasting it back into its original format.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>Are There Any Limitations to Transposing Data in Excel? <\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\t<strong>Yes<\/strong>, there are certain limitations to transposing data in Excel. So, enormously large datasets might need alternative methods or tools for transposition.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How Do I Flip Columns and Rows in Excel?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can flip columns and rows in Excel by selecting the data that you want to flip. Then, click <strong>Data<\/strong> tab &gt;&gt; <strong>From Table\/Range<\/strong> option. This will simply launch the Power Query Editor, where you can check a Transpose option in order to flip the columns &amp; rows.                    <\/p>\n                <\/div>\n            <\/div>\n        <\/section>\n\t\t\n<script type=\"application\/ld+json\">\n    {\n\t\t\"@context\": \"https:\/\/schema.org\",\n\t\t\"@type\": \"FAQPage\",\n\t\t\"mainEntity\": [\n\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Main Purpose of Data Transposition in Excel? \",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"The main purpose of data transposition in Excel is to rearrange the data from columns to rows or vice versa and make it more appropriate for analysis or presentation.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"What Is the Shortcut for Transpose in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>Ctrl + Alt + V<\/strong> is a shortcut for transpose in Excel.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Can I Undo a Data Transposition in Excel? \",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Yes, you can undo a data transposition in by copying original data &amp; pasting it back into its original format.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"Are There Any Limitations to Transposing Data in Excel? \",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"<strong>Yes<\/strong>, there are certain limitations to transposing data in Excel. So, enormously large datasets might need alternative methods or tools for transposition.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t,\t\t\t\t{\n\t\t\t\t\"@type\": \"Question\",\n\t\t\t\t\"name\": \"How Do I Flip Columns and Rows in Excel?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can flip columns and rows in Excel by selecting the data that you want to flip. Then, click <strong>Data<\/strong> tab &gt;&gt; <strong>From Table\/Range<\/strong> option. This will simply launch the Power Query Editor, where you can check a Transpose option in order to flip the columns &amp; rows.\"\n\t\t\t\t\t\t\t\t\t}\n\t\t\t}\n\t\t\t\t    ]\n}\n<\/script>\n\n<h2 style=\"text-align: left;\"><strong>Final Words<\/strong><\/h2>\n<p style=\"text-align: justify;\">Now, with this brief guide, <strong>transposing Excel data<\/strong> is no longer a hectic task as you can easily rotate data from rows to columns or vice versa in no time.<\/p>\n<p style=\"text-align: justify;\">I hope the article is useful for you and helps in solving your queries regarding data transposing.<\/p>\n<p style=\"text-align: justify;\">Besides this, if you end up losing your Excel file data due to corruption issues, you can go with the recommended solution <strong><a href=\"https:\/\/www.repairmsexcel.com\/download-excel-repair.php\" target=\"_blank\" rel=\"noopener\">Excel repair tool<\/a>. <\/strong>It is an advanced software that allows <strong>repairing corrupt or damaged Excel file data <\/strong>with 100% integrity<strong>.\u00a0<\/strong><\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><strong>References:<\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71<\/a><\/li>\n<\/ol>\n<\/div><\/div>\n<br><center><a href='https:\/\/www.repairmsexcel.com\/blog\/free-download-now' title='Try Excel Repair Now'><img src='https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-en.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Very often users have to face a situation where their data in the MS Excel spreadsheet isn\u2019t in the correct &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#more-6242\" aria-label=\"Read more about How to Transpose Data in Excel? &#8211; A Step-By-Step Guide\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":7302,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[1347,1349,1348],"class_list":["post-6242","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-transpose-data-in-excel","tag-transpose-data-from-rows-to-columns-in-excel","tag-transpose-data-in-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Transpose Data in Excel? - A Step-By-Step Guide<\/title>\n<meta name=\"description\" content=\"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized &amp; presentable\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Transpose Data in Excel? - A Step-By-Step Guide\" \/>\n<meta property=\"og:description\" content=\"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized &amp; presentable\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-30T04:20:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-02T07:25:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priyanka Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priyanka Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide\",\"datePublished\":\"2023-10-30T04:20:49+00:00\",\"dateModified\":\"2023-11-02T07:25:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\"},\"wordCount\":1378,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png\",\"keywords\":[\"how to transpose data in Excel\",\"Transpose data from rows to columns in Excel\",\"Transpose Data in Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\",\"name\":\"How to Transpose Data in Excel? - A Step-By-Step Guide\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png\",\"datePublished\":\"2023-10-30T04:20:49+00:00\",\"dateModified\":\"2023-11-02T07:25:36+00:00\",\"description\":\"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized & presentable\u2026\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png\",\"width\":550,\"height\":300,\"caption\":\"how to Transpose Data in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"name\":\"Repair MS Excel\",\"description\":\"Get Tips, Tricks and Fixes of MS Excel Issues\",\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\",\"name\":\"Repair MS Excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Repair MS Excel\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\",\"name\":\"Priyanka Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g\",\"caption\":\"Priyanka Sahu\"},\"description\":\"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.\",\"sameAs\":[\"https:\/\/www.repairmsexcel.com\/\",\"https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242\"],\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Transpose Data in Excel? - A Step-By-Step Guide","description":"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized & presentable\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Transpose Data in Excel? - A Step-By-Step Guide","og_description":"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized & presentable\u2026","og_url":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2023-10-30T04:20:49+00:00","article_modified_time":"2023-11-02T07:25:36+00:00","og_image":[{"width":550,"height":300,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide","datePublished":"2023-10-30T04:20:49+00:00","dateModified":"2023-11-02T07:25:36+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel"},"wordCount":1378,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png","keywords":["how to transpose data in Excel","Transpose data from rows to columns in Excel","Transpose Data in Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel","name":"How to Transpose Data in Excel? - A Step-By-Step Guide","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png","datePublished":"2023-10-30T04:20:49+00:00","dateModified":"2023-11-02T07:25:36+00:00","description":"Get an idea of how to transpose data in Excel with this brief guide and learn to make your spreadsheet data more organized & presentable\u2026","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2023\/10\/How-to-Transpose-Data-in-Excel.png","width":550,"height":300,"caption":"how to Transpose Data in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/transpose-data-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Transpose Data in Excel? &#8211; A Step-By-Step Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.repairmsexcel.com\/blog\/#website","url":"https:\/\/www.repairmsexcel.com\/blog\/","name":"Repair MS Excel","description":"Get Tips, Tricks and Fixes of MS Excel Issues","publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization","name":"Repair MS Excel","url":"https:\/\/www.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Repair MS Excel"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3","name":"Priyanka Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/7e53e98dbd92755427e57013018cbed29ee3ae27e0a21f434dbd1ee1ce867558?s=96&d=mm&r=g","caption":"Priyanka Sahu"},"description":"Priyanka is a content marketing expert. She writes tech blogs and has expertise in MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in the easy-to-understand language is very impressive. When not writing, she loves unplanned travels.","sameAs":["https:\/\/www.repairmsexcel.com\/","https:\/\/www.linkedin.com\/in\/priyanka-sahu-2794a1242"],"url":"https:\/\/www.repairmsexcel.com\/blog\/author\/priyanka"}]}},"_links":{"self":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=6242"}],"version-history":[{"count":5,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6242\/revisions"}],"predecessor-version":[{"id":7341,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/6242\/revisions\/7341"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/7302"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=6242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=6242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=6242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}