{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Main Sheet","Used Merge From Ribbon","Used Consolidate","Used Formula","Used VBA"],"not_rendered":{"charts":0,"images":0,"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":"Main Sheet","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null," ","Excel Merge Rows with Same Value"]
[]
[null,null,"First Name","Product Name","Product Price"]
[null,null,"Ahmed ","Formal wear",200]
[null,null,"Ahmed ","Punjabi",150]
[null,null,"Alan","Tie",20]
[null,null,"Victor","Shirts",30]
[null,null,"Jerry","Watch",80]
[null,null,"Alekxander","Denim Jackets",25]
[null,null,"Jim","T-shirt",5]
[null,null,"jim","Sneaker",150]
[null,null,"Victor","Shoes",110]
[null,null,"Victor","Watch",50]

{"sheet":"Used Merge From Ribbon","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,4,1],[8,1,9,1]]}
[null,"Excel Merge Rows with Same Value"]
[]
[null,"First Name","Product Name","Product Price"]
[null,"Ahmed ","Formal wear",200]
[null,null,"Punjabi",150]
[null,"Alan","Tie",20]
[null,"Alekxander","Shirts",25]
[null,"Jerry","Watch",80]
[null,"Jim","Denim Jackets",150]
[null,null,"T-shirt",5]
[null,"Victor","Sneaker",30]
[null,null,"Shoes",110]
[null,null,"Watch",50]

{"sheet":"Used Consolidate","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[" ","Excel Merge Rows with Same Value"]
[]
[null,"First Name","Product Name","Product Price"]
[null,"Ahmed ","Formal wear",200]
[null,"Ahmed ","Punjabi",150]
[null,"Alan","Tie",20]
[null,"Victor","Shirts",30]
[null,"Jerry","Watch",80]
[null,"Alekxander","Denim Jackets",25]
[null,"Jim","T-shirt",5]
[null,"jim","Sneaker",150]
[null,"Victor","Shoes",110]
[null,"Victor","Watch",50]
[]
[null,"First Name",null,"Product Price"]
[null,"Ahmed ",null,350]
[null,"Alan",null,20]
[null,"Victor",null,190]
[null,"Jerry",null,80]
[null,"Alekxander",null,25]
[null,"Jim",null,155]

{"sheet":"Used Formula","index":3,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Excel Merge Rows with Same Value"]
[]
[null,"First Name","Product Name","Product Price","Merged Rows With Same Value"]
[null,"Ahmed ","Formal wear",200,{"$f":"IF(B4=B3,E3&\", \"&C4,C4)","v":"Formal wear"}]
[null,"Ahmed ","Punjabi",150,"Formal wear, Punjabi"]
[null,"Alan","Tie",20,"Tie"]
[null,"Alekxander","Shirts",25,"Shirts"]
[null,"Jerry","Watch",80,"Watch"]
[null,"Jim","Denim Jackets",150,"Denim Jackets"]
[null,"Jim","T-shirt",5,"Denim Jackets, T-shirt"]
[null,"Victor","Sneaker",30,"Sneaker"]
[null,"Victor","Shoes",110,"Sneaker, Shoes"]
[null,"Victor","Watch",50,"Sneaker, Shoes, Watch"]

{"sheet":"Used VBA","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,4,1],[8,1,9,1],[10,1,12,1]]}
[null,"Excel Merge Rows with Same Value"]
[]
[null,"First Name","Product Name","Product Price"]
[null,"Ahmed ","Formal wear",200]
[null,null,"Punjabi",150]
[null,"Alan","Tie",20]
[null,"Alekxander","Shirts",25]
[null,"Jerry","Watch",80]
[null,"Jim","Denim Jackets",150]
[null,null,"T-shirt",5]
[null,"Victor","Sneaker",30]
[null,null,"Shoes",110]
[null,null,"Watch",50]