{"id":1774,"date":"2025-06-05T12:52:28","date_gmt":"2025-06-05T12:52:28","guid":{"rendered":"http:\/\/www.repairmsexcel.com\/blog\/?p=1774"},"modified":"2025-06-11T08:57:20","modified_gmt":"2025-06-11T08:57:20","slug":"merge-rows-and-columns-in-excel","status":"publish","type":"post","link":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel","title":{"rendered":"How to Merge Rows and Columns in Excel Without Losing Data?"},"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;\">Merging rows and columns in Microsoft Excel can improve your spreadsheet&#8217;s appearance &amp; readability. Whether you&#8217;re designing a report or formatting a table, knowing how to merge cells efficiently is essential. In this helpful guide, you will learn <strong>how to merge rows and columns in Excel <\/strong>with ease.<\/p>\n<p><!--more--><\/p>\n<div style='margin: 8px 0; clear: both;'><div style='background: #eafdeb; padding: 12px;'><p><strong style='font-size: 18px;'>To recover Excel data without any data loss, 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<h2 style=\"text-align: left;\"><strong>How To Merge Rows And Columns In Excel Without Losing Data?<\/strong><\/h2>\n<p style=\"text-align: justify;\">There are different methods for combining row and columns text in Excel. Here, check the ways one by one to merge data without losing it. First, check <strong>how to merge rows in Excel.<\/strong><\/p>\n<h2 style=\"text-align: left;\"><strong>Part 1# <\/strong><strong>How to Merge Rows in Excel<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1781\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel.png\" alt=\"\" width=\"531\" height=\"251\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel.png 531w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-rows-excel-300x142.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/p>\n<p style=\"text-align: justify;\">When it comes to merging the Excel rows there are two ways that allow you to merge rows data easily.<\/p>\n<ol style=\"text-align: justify;\">\n<li><strong>Merge Excel rows using a formula<\/strong><\/li>\n<li><strong>Combine multiple rows using the Merge Cells add-in<\/strong><\/li>\n<\/ol>\n<h3><strong>1. How to Merge Multiple Rows using Excel Formulas<\/strong><\/h3>\n<p style=\"text-align: justify;\">Excel provides various formulas that help you combine data from different rows. Possibly the easiest one is the <strong>CONCATENATE function<\/strong>. So here checks out some examples for concatenating numerous rows into one:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Merge rows with spaces between data<\/strong>: For example <strong>=CONCATENATE(B1,&#8221; &#8220;,B2,&#8221; &#8220;,B3)<\/strong><\/li>\n<li><strong>Combine rows without any space between the values<\/strong>: For example <strong>=CONCATENATE(A1<\/strong>,<strong>A2,A3)<\/strong><\/li>\n<li><strong>Merge rows &gt; separate the values with comma:<\/strong> For Example <strong>=CONCATENATE(A1,&#8221;, &#8220;,A2,&#8221;, &#8220;,A3)<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Now check how the CONCATENATE formula works on the real data.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1780\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge.png\" alt=\"\" width=\"533\" height=\"181\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge.png 533w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/rows-to-merge-300x102.png 300w\" sizes=\"auto, (max-width: 533px) 100vw, 533px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>On the sheet choose an empty cell and type the formula into it. Type the formula as per the data rows<\/li>\n<li>And copy the formula across entire other cells in the row.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1779\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula.png\" alt=\"\" width=\"637\" height=\"256\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula.png 637w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-formula-300x121.png 300w\" sizes=\"auto, (max-width: 637px) 100vw, 637px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now, simply you are having several data rows merged into one row.<\/li>\n<\/ul>\n<h3 style=\"text-align: left;\"><strong>2. How to Combine Rows in Excel using the Merge Cells Add-in<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1778\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-cells-excel.png\" alt=\"\" width=\"229\" height=\"116\" \/><\/p>\n<p style=\"text-align: justify;\">The <strong>Merge Cells add-in<\/strong> is used for merging various types of cells in Excel. This allows you to merges the individual cells and also combines data from entire rows or columns.<\/p>\n<p style=\"text-align: justify;\"><strong><span style=\"color: #ff0000;\">Please Note<\/span>:<\/strong> You need to download a merge cell add-ins for third-party sites available online. Search in Google for add-ins.<\/p>\n<p style=\"text-align: justify;\"><strong>Follow the given steps to combine two or more rows in your table:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose <strong>rows<\/strong> you are looking to merge &gt; click on the <strong>Merge Cells icon<\/strong>.<\/li>\n<li>Now the <strong>merge cells dialog window<\/strong> opens with a table or range selected already. And in the upper part of the window, you can see the three basic things:<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1777\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin.png\" alt=\"\" width=\"360\" height=\"371\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin.png 360w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin-291x300.png 291w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-addin-300x309.png 300w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong><em>How you want to join cells<\/em> <\/strong>\u2013 For combining rows of data &gt; choose &#8220;<strong>column by column<\/strong>&#8220;.<\/li>\n<li style=\"text-align: justify;\"><strong><em>How to separate merged values<\/em> with<\/strong> \u2013 an array of standard separators is available to choose from &gt; <strong>comma, space, semicolon, and<\/strong> <strong>a\u00a0line break. <\/strong>So select the separator as per your desire.<\/li>\n<li><em><strong>Where you need to place the merged cells<\/strong><\/em> &gt; either the top cell or the bottom cell?<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Now, check the lower part of the Windows to check if you need any additional options:<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1776\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options.png\" alt=\"\" width=\"360\" height=\"371\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options.png 360w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options-291x300.png 291w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-options-300x309.png 300w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"text-align: justify;\"><strong><em>Clear the content of selected cells<\/em><\/strong> &#8211; Choose this if need data to remain in the merged cells only.<\/li>\n<li style=\"text-align: justify;\"><strong><em>Merge all areas in the selection<\/em><\/strong><em> \u2013 <\/em>This option allows you to merge rows in two or more non-adjacent ranges.<\/li>\n<li style=\"text-align: justify;\"><strong><em>Skip empty cells<\/em><\/strong><strong> and <em>Wrap text<\/em><\/strong> \u2013 Well, these are self-explanatory.<\/li>\n<li style=\"text-align: justify;\"><strong>Lastly, <em>Create a backup copy of the worksheet<\/em><\/strong><em> &#8211; <\/em>This option is checked by default. \u00a0It is just a precaution that keeps you on the safe side and prevents the risk of data loss.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li>Click the <strong>Merge <\/strong>button &gt; to check the result \u2013 possible the merged rows of data separated by line breaks.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">So, these are the two ways that allow you to <strong>merge rows in Excel<\/strong> without any data loss. Now, check out the ways on <strong>how to combine two columns in Excel.<\/strong><\/p>\n<blockquote><p><strong><span style=\"color: #ff0000;\">Also Read<\/span>: <a class=\"row-title\" href=\"https:\/\/www.repairmsexcel.com\/blog\/wp-admin\/post.php?post=9016&amp;action=edit\" aria-label=\"\u201cHow to Remove Green Triangle in Excel? \u2013 Updated &amp; Easy Guide!\u201d (Edit)\">How to Remove Green Triangle in Excel? \u2013 Updated &amp; Easy Guide!<\/a><\/strong><\/p><\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Part 2# How to Merge Columns in Excel\u00a0<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1795\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel.png\" alt=\"\" width=\"477\" height=\"160\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel.png 477w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-2-columns-excel-300x101.png 300w\" sizes=\"auto, (max-width: 477px) 100vw, 477px\" \/><\/p>\n<p style=\"text-align: justify;\">Here, check out the 3 ways to merge data from several columns into one without using VBA macro.<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>Merge two columns using formulas<\/strong><\/li>\n<li><strong>Combine columns data via NotePad<\/strong><\/li>\n<li><strong>The fastest way to join multiple columns<\/strong><\/li>\n<\/ul>\n<h3 style=\"text-align: justify;\"><strong>1. Merge Two Columns Using Excel Formulas<\/strong><\/h3>\n<p style=\"text-align: justify;\">1. Into your table &gt; insert a new column &gt; in the column header, place the mouse pointer &gt; right-click the mouse &gt; select <strong>Insert<\/strong> from the context menu. Name the newly added columns for eg. \u2013 <strong>\u201cFull Name\u201d<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1792\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column.png\" alt=\"\" width=\"606\" height=\"160\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column.png 606w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/insert-new-column-300x79.png 300w\" sizes=\"auto, (max-width: 606px) 100vw, 606px\" \/><\/p>\n<p style=\"text-align: justify;\">2. In the cell D2, write the formula: <strong>=CONCATENATE(B2,&#8221; &#8220;,C2). <\/strong>The B2 and C2 are the addresses of <strong>First Name and Last Name.<\/strong> And in the formula, the <strong>quotation marks &#8220;&#8221;\u00a0<\/strong>is the separator that will be inserted between merged names any other symbol can be used as a separator e.g. a comma.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1791\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space.png\" alt=\"\" width=\"432\" height=\"163\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space.png 432w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-2-cells-with-space-300x113.png 300w\" sizes=\"auto, (max-width: 432px) 100vw, 432px\" \/><\/p>\n<p>3. Just like this, join data from several cells into one by making use of any separator of your choice.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1790\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns.png\" alt=\"\" width=\"568\" height=\"166\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns.png 568w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-address-columns-300x88.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/p>\n<p>4. Simply, copy the formula to other cells of the Full Name column. If the <strong>First name or the Last name <\/strong>is deleted, then the corresponding data in the Full name Column will also be gone.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1789\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names.png\" alt=\"\" width=\"354\" height=\"167\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names.png 354w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combined-names-300x142.png 300w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/p>\n<p style=\"text-align: justify;\">5. Next, try converting the formula to a value so that you can remove the unnecessary columns from the Excel worksheet. Choose entire cells with data in the merged column (choose the first cell in <strong>\u201cFull Name\u201d Column<\/strong> &gt; press <strong>Ctrl +Shift + Arrow Down<\/strong>)<\/p>\n<p style=\"text-align: justify;\">6. Now copy the contents of the columns to clipboard &gt; right click on the cell in the same column <strong>(\u201cFull Name\u201d)<\/strong> &gt; choose <strong>\u201cPaste Special\u201d <\/strong>context menu &gt; choose <strong>\u201cValues\u201d <\/strong>radio button &gt; click <strong>OK.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1796\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values.png\" alt=\"\" width=\"492\" height=\"414\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values.png 492w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/combine-paste-values-300x252.png 300w\" sizes=\"auto, (max-width: 492px) 100vw, 492px\" \/><\/p>\n<p style=\"text-align: justify;\">7. Now remove <strong>&#8220;First Name&#8221; &amp; &#8220;Last Name&#8221;<\/strong> columns that are not required. Click the column <strong>B header <\/strong>&gt; press and hold <strong>Ctrl &gt; <\/strong>click column <strong>C header.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1788\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns.png\" alt=\"\" width=\"338\" height=\"261\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns.png 338w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/delete-merged-columns-300x232.png 300w\" sizes=\"auto, (max-width: 338px) 100vw, 338px\" \/><\/p>\n<p>8. After that make a right-click on any selected columns &gt; select <strong>Delete <\/strong>from the context menu.<\/p>\n<p>9. This is it, now you have successfully merged the names from 2 columns into one.<\/p>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1787\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined.png\" alt=\"\" width=\"451\" height=\"166\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined.png 451w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/two-columns-combined-300x110.png 300w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/h3>\n<h3 style=\"text-align: justify;\"><strong>2. Combine columns Data via Notepad<\/strong><\/h3>\n<p style=\"text-align: justify;\">This is another way that allows you to merge several columns. Here you don\u2019t need any formulas. This is suitable for combining adjacent columns to make use of the same delimiter for all of them.<\/p>\n<p style=\"text-align: justify;\"><strong>For Example<\/strong>: If looking for combining 2 columns with <strong>First Names and Last Names<\/strong> into one:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Choose both columns you need to merge: Click <strong>B1<\/strong> &gt; press <strong>Shift + ArrrowRight<\/strong> for choosing <strong>C1 &gt; <\/strong>then hit<strong> Ctrl + Shift + ArrowDown<\/strong> for choosing entire data cells with data in two columns.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1786\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list.png\" alt=\"\" width=\"520\" height=\"163\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list.png 520w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/customers-list-300x94.png 300w\" sizes=\"auto, (max-width: 520px) 100vw, 520px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>And <strong>copy data to clipboard<\/strong> &gt; open <strong>Notepad &gt;<\/strong> insert data from the clipboard to the Notepad<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1785\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad.png\" alt=\"\" width=\"438\" height=\"222\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad.png 438w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/paste-excel-columns-notepad-300x152.png 300w\" sizes=\"auto, (max-width: 438px) 100vw, 438px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Then copy tab character to clipboard &gt; hit Tab right in Notepad &gt; hit <strong>Ctrl + Shift + LeftArrow <\/strong>&gt; press <strong>Ctrl + X.<\/strong><\/li>\n<li>After that <strong>Replace Tab characters in Notepad with the separator<\/strong>, you require.<\/li>\n<li>Hit <strong>Ctrl + H<\/strong> for opening the <strong>\u201cReplace\u201d <\/strong>dialog box &gt; paste the Tab character from the clipboard in <strong>Find what <\/strong>field &gt; type the separator <strong> Space, comma etc<\/strong> in <strong>\u201cReplace with\u201d <\/strong>field. Hit the <strong>Replace All<\/strong> button<strong> &gt;<\/strong> to close the dialog box press <strong>Cancel<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1784\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces.png\" alt=\"\" width=\"548\" height=\"329\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces.png 548w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/replace-tab-spaces-300x180.png 300w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Now select the entire text in the Notepad and copy it to Clipboard.<\/li>\n<li>Then switch back to Excel worksheet (<strong>press Alt + Tab<\/strong>) &gt; choose B1 cell and paste text from Clipboard to your table.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1783\" src=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns.png\" alt=\"\" width=\"571\" height=\"163\" srcset=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns.png 571w, https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merged-text-from-two-columns-300x86.png 300w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>And rename column B to <strong>&#8220;<em>Full Name<\/em>&#8220;<\/strong> and remove the &#8220;<em>Last name<\/em>&#8221; column.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">So, this is the second way that allows you to merge columns in Excel without any data loss.<\/p>\n<h3 style=\"text-align: justify;\"><strong>3. Join Columns Using Merge Cells Add-in For Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">This is the easiest and quickest way to combine data from numerous Excel columns into one. Just make use of the third party merge cells add-in for Excel.<\/p>\n<p style=\"text-align: justify;\">And with the merge cells add-in, you can merge data from many cells by using any separator you like (<strong>for example carriage return or line break<\/strong>). With this, you can join row by row, column by column, or merge data from the selected cell into one without any loss.<\/p>\n<p style=\"text-align: justify;\">There are many third-party add-ins sites online that allow you to download the add-ins and merge the cells easily in just a few clicks.<\/p>\n<h2 style=\"text-align: left;\"><strong>Frequently Asked Questions:<\/strong><\/h2>\n        <section class=\"sc_fs_faq sc_card \">\n            <div>\n\t\t\t\t<h3>How to Merge Two Rows and Columns in an Existing Table?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tYou can combine two rows or columns in an existing table by following the below steps: <ul><li>Select the cell(s) to merge. <\/li><li>On a table's Layout tab, choose Merge Cells in a Merge group.                     <\/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>When I Merge Cells, The Text Disappears in Excel.?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tMany times, text disappears in Excel when merging cells and hinders in workflow. At the time, you have to right-click on a cell &gt;&gt; choose \u2018Format Cells.\u2019                    <\/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>Is There a Way to Merge Two Cells in Sheets and Keep All Data?<\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tBy using CONCATENATE formula, you can merge cells in sheets and keep all data in it. Excel provides various formulas and functions, CONCATENATE is one of them.                    <\/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><\/h3>                <div>\n\t\t\t\t\t                    <p>\n\t\t\t\t\t\tTo merge two cells in Excel and keep the same data with a space, choose the cell you want to put a combined data. Then, type =CONCAT. Use commas to isolate the cells you\u2019re combining, commas, use quotation marks to add spaces, other text, or the ampersand symbol (&amp;) with the next cell that you want to combine.                    <\/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\": \"How to Merge Two Rows and Columns in an Existing Table?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"You can combine two rows or columns in an existing table by following the below steps: &lt;ul&gt;&lt;li&gt;Select the cell(s) to merge. &lt;\/li&gt;&lt;li&gt;On a table's Layout tab, choose Merge Cells in a Merge group.\"\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\": \"When I Merge Cells, The Text Disappears in Excel.?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"Many times, text disappears in Excel when merging cells and hinders in workflow. At the time, you have to right-click on a cell &gt;&gt; choose \u2018Format Cells.\u2019\"\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\": \"Is There a Way to Merge Two Cells in Sheets and Keep All Data?\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"By using CONCATENATE formula, you can merge cells in sheets and keep all data in it. Excel provides various formulas and functions, CONCATENATE is one of them.\"\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\": \"\",\n\t\t\t\t\"acceptedAnswer\": {\n\t\t\t\t\t\"@type\": \"Answer\",\n\t\t\t\t\t\"text\": \"To merge two cells in Excel and keep the same data with a space, choose the cell you want to put a combined data. Then, type =CONCAT. Use commas to isolate the cells you\u2019re combining, commas, use quotation marks to add spaces, other text, or the ampersand symbol (&amp;) with the next cell that you want to combine.\"\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>Time to Sum Up<\/strong><\/h2>\n<p style=\"text-align: justify;\">Merging cells in Excel helps format your spreadsheets more clearly. Whether you\u2019re combining columns for a title or merging rows for better readability, follow the steps above to <strong>merge rows and columns in Excel <\/strong>effectively. For data safety, always back up before merging.<\/p>\n<p>Keep your Excel sheets organized and professional with these easy tips!<\/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>External References:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/merge-or-split-cells-in-a-table-8b458deb-0fc5-4c8d-8d94-2d4da98193f8\" target=\"_blank\" rel=\"noopener\">https:\/\/support.microsoft.com\/en-us\/office\/merge-or-split-cells-in-a-table-8b458deb-0fc5-4c8d-8d94-2d4da98193f8<\/a><\/li>\n<\/ul>\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>Merging rows and columns in Microsoft Excel can improve your spreadsheet&#8217;s appearance &amp; readability. Whether you&#8217;re designing a report or &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Merge Rows and Columns in Excel Without Losing Data?\" class=\"read-more button\" href=\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#more-1774\" aria-label=\"Read more about How to Merge Rows and Columns in Excel Without Losing Data?\">Read more<\/a><\/p>\n","protected":false},"author":5,"featured_media":1797,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[632],"tags":[980,495,496],"class_list":["post-1774","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","tag-how-to-merge-rows-in-excel","tag-merge-columns-and-rows-in-excel","tag-merge-row-and-columns-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 Merge Rows and Columns in Excel Without Losing Data?<\/title>\n<meta name=\"description\" content=\"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.\" \/>\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\/merge-rows-and-columns-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 Merge Rows and Columns in Excel Without Losing Data?\" \/>\n<meta property=\"og:description\" content=\"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel File Repair Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-05T12:52:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T08:57:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"690\" \/>\n\t<meta property=\"og:image:height\" content=\"370\" \/>\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=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\"},\"author\":{\"name\":\"Priyanka Sahu\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3\"},\"headline\":\"How to Merge Rows and Columns in Excel Without Losing Data?\",\"datePublished\":\"2025-06-05T12:52:28+00:00\",\"dateModified\":\"2025-06-11T08:57:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\"},\"wordCount\":1631,\"publisher\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png\",\"keywords\":[\"how to merge rows in excel\",\"merge columns and rows in excel\",\"merge row and columns data in Excel\"],\"articleSection\":[\"Tutorials\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\",\"name\":\"How to Merge Rows and Columns in Excel Without Losing Data?\",\"isPartOf\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png\",\"datePublished\":\"2025-06-05T12:52:28+00:00\",\"dateModified\":\"2025-06-11T08:57:20+00:00\",\"description\":\"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage\",\"url\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png\",\"contentUrl\":\"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png\",\"width\":690,\"height\":370,\"caption\":\"merge columns and rows in excel,\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.repairmsexcel.com\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Merge Rows and Columns in Excel Without Losing Data?\"}]},{\"@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 Merge Rows and Columns in Excel Without Losing Data?","description":"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.","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\/merge-rows-and-columns-in-excel","og_locale":"en_US","og_type":"article","og_title":"How to Merge Rows and Columns in Excel Without Losing Data?","og_description":"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.","og_url":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel","og_site_name":"Excel File Repair Blog","article_published_time":"2025-06-05T12:52:28+00:00","article_modified_time":"2025-06-11T08:57:20+00:00","og_image":[{"width":690,"height":370,"url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png","type":"image\/png"}],"author":"Priyanka Sahu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Priyanka Sahu","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#article","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel"},"author":{"name":"Priyanka Sahu","@id":"https:\/\/www.repairmsexcel.com\/blog\/#\/schema\/person\/ab2250dcc6b25c12e617748b1fc166e3"},"headline":"How to Merge Rows and Columns in Excel Without Losing Data?","datePublished":"2025-06-05T12:52:28+00:00","dateModified":"2025-06-11T08:57:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel"},"wordCount":1631,"publisher":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png","keywords":["how to merge rows in excel","merge columns and rows in excel","merge row and columns data in Excel"],"articleSection":["Tutorials"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel","url":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel","name":"How to Merge Rows and Columns in Excel Without Losing Data?","isPartOf":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage"},"image":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage"},"thumbnailUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png","datePublished":"2025-06-05T12:52:28+00:00","dateModified":"2025-06-11T08:57:20+00:00","description":"Want to know how to merge cells in Excel without losing data? Read this article to merge rows and columns in Excel without data loss.","breadcrumb":{"@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#primaryimage","url":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png","contentUrl":"https:\/\/www.repairmsexcel.com\/blog\/wp-content\/uploads\/2018\/06\/merge-rows-column-in-excel.png","width":690,"height":370,"caption":"merge columns and rows in excel,"},{"@type":"BreadcrumbList","@id":"https:\/\/www.repairmsexcel.com\/blog\/merge-rows-and-columns-in-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"How to Merge Rows and Columns in Excel Without Losing Data?"}]},{"@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\/1774","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=1774"}],"version-history":[{"count":3,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1774\/revisions"}],"predecessor-version":[{"id":9052,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1774\/revisions\/9052"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/1797"}],"wp:attachment":[{"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=1774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=1774"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=1774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}