{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Home Page","Data","1.1 TEXTJOIN","1.2 CONCAT","2. Clipboard","3. Ampersand","4. Notepad","5. VBA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"How to Merge Rows Without Losing Data in Excel"]
[]
[null,"Learn to merge rows without losing data in Excel with this free workbook. Read the article we provided and practice these in practice section."]
[]
[null,"Prepared By:","Qayem Ishrak Khan"]
[null,"Reviewed By:","Masum Mahdy"]
[null,"Last Update:","2024-01-09"]
[null,"Article Link:","Excel Sparklines"]
[]
[null,"Methods"]
[]
[null,"Dataset"]
[null,"1.1 Using TEXTJOIN Function"]
[null,"1.2 Using CONCAT Function"]
[null,"2. Using Clipboard Feature"]
[null,"3. Using Ampersand Operator"]
[null,"4. Using Notepad"]
[null,"5. Applying VBA Code"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Copyright © 2013-2023 ExcelDemy.com | All rights reserved."]

{"sheet":"Data","index":1,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Merge Rows Without Losing Data"]
[]
[null,"Data"]
[]
[null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.1 TEXTJOIN","index":2,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"Using Excel Functions"]
[]
[null,"TEXTJOIN Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,null,"Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[]
[null,"Merged Rows"]
[null,{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B6:B12)","v":"Sadman Kaiser, Antony Hopper, Prottoy Roy, James Caven, Joe Root, Swaty Malhotra"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"1.2 CONCAT","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Using Excel Functions"]
[]
[null,"CONCAT Function",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[null,"Merged Rows"]
[null,{"$f":"_xlfn.CONCAT(B6,B7,B8,B9,B10,B11,B12)","v":"Sadman KaiserAntony HopperProttoy RoyHarold FinchJames CavenJoe RootSwaty Malhotra"}]
[null,{"$f":"_xlfn.FORMULATEXT(B15)","v":"=CONCAT(B6,B7,B8,B9,B10,B11,B12)"}]
[null,"Without separator"]
[]
[null,"Merged Rows"]
[null,{"$f":"_xlfn.CONCAT(B6,\", \",B7,\", \",B8,\", \",B9,\", \",B10,\", \",B11,\", \",B12)","v":"Sadman Kaiser, Antony Hopper, Prottoy Roy, Harold Finch, James Caven, Joe Root, Swaty Malhotra"}]
[null,{"$f":"_xlfn.FORMULATEXT(B20)","v":"=CONCAT(B6,\", \",B7,\", \",B8,\", \",B9,\", \",B10,\", \",B11,\", \",B12)"}]
[null,"With separator (Comma and Space)"]
[]
[null,"It is recommended to use CONCAT function instead of CONCATENATE as both offers same features. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"2. Clipboard","index":4,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Using Copy Paste Command",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[]
[null,"Merged Rows"]
[null,"Sadman Kaiser\nAntony Hopper\nProttoy Roy\nHarold Finch\nJames Caven\nJoe Root\nSwaty Malhotra"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"3. Ampersand","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[]
[null,"Merged Rows","Formula","Note"]
[null,{"$f":"B4&\", \"&B5&\", \"&B6&\", \"&B7&\", \"&B8&\", \"&B9&\", \"&B10","v":"Sadman Kaiser, Antony Hopper, Prottoy Roy, Harold Finch, James Caven, Joe Root, Swaty Malhotra"},{"$f":"_xlfn.FORMULATEXT(B14)","v":"=B4&\", \"&B5&\", \"&B6&\", \"&B7&\", \"&B8&\", \"&B9&\", \"&B10"},"Here \", \" used Comma and Space as separator"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"4. Notepad","index":6,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Using Notepad",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[]
[null,"Merged Rows"]
[null,"Sadman Kaiser\nAntony Hopper\nProttoy Roy\nHarold Finch\nJames Caven\nJoe Root\nSwaty Malhotra"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]

{"sheet":"5. VBA","index":7,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Customer Name","Sold Items ","Quantity",null,null,null,null,null,null,null,null,"Customer Name","Sold Items ","Quantity"]
[null,"Sadman Kaiser","Pencil",12,null,null,null,null,null,null,null,null,"Sadman Kaiser","Pencil",12]
[null,"Antony Hopper","Pen",10,null,null,null,null,null,null,null,null,"Antony Hopper","Pen",10]
[null,"Prottoy Roy","Notebook",4,null,null,null,null,null,null,null,null,"Prottoy Roy","Notebook",4]
[null,"Harold Finch","Book",20,null,null,null,null,null,null,null,null,"Harold Finch","Book",20]
[null,"James Caven","Calculator",1,null,null,null,null,null,null,null,null,"James Caven","Calculator",1]
[null,"Joe Root","Book",12,null,null,null,null,null,null,null,null,"Joe Root","Book",12]
[null,"Swaty Malhotra","Pen",6,null,null,null,null,null,null,null,null,"Swaty Malhotra","Pen",6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Back to Home Page"]