{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Sheet1","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7]]}
["Fruits"]
["apple",10,11,8,null,4]
["orange",9,9]
["apple",11,11]
["apple",14,10,10,5]
["grapes",15,15,14,3]
[]
[]
[]
["File downloaded from:",null,null,"Merge matching rows"]
["My excel site: ",null,null,"Get Digital Help"]
["RSS feed:",null,null,"RSS"]
["Newsletter:",null,null,"Newsletter"]

{"sheet":"Sheet2","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7]]}
["Fruits"]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet2!$A$1:A1,Sheet1!$A$2:$A$6),0))","v":"apple"},{"$f":"MergeMatchingRows($A2,Sheet1!$A$2:$F$6)","v":10},11,8,4,11,11,14,10,10,5,"",""]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet2!$A$1:A2,Sheet1!$A$2:$A$6),0))","v":"orange"},{"$f":"MergeMatchingRows($A3,Sheet1!$A$2:$F$6)","v":9},9,"","","","","","","","","",""]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet2!$A$1:A3,Sheet1!$A$2:$A$6),0))","v":"grapes"},{"$f":"MergeMatchingRows($A4,Sheet1!$A$2:$F$6)","v":15},15,14,3,"","","","","","","",""]
[]
[]
[]
[]
[]
["File downloaded from:",null,null,"Merge matching rows"]
["My excel site: ",null,null,"Get Digital Help"]
["RSS feed:",null,null,"RSS"]
["Newsletter:",null,null,"Newsletter"]

{"sheet":"Sheet3","index":2,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,3,9,7],[10,3,10,7],[11,3,11,7],[12,3,12,7]]}
["Fruits"]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet3!$A$1:A1,Sheet1!$A$2:$A$6),0))","v":"apple"},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(A1)),COLUMN(A1)-(ROUNDDOWN((COLUMN(A1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":10},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(B1)),COLUMN(B1)-(ROUNDDOWN((COLUMN(B1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":11},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(C1)),COLUMN(C1)-(ROUNDDOWN((COLUMN(C1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":8},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(D1)),COLUMN(D1)-(ROUNDDOWN((COLUMN(D1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":11},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(E1)),COLUMN(E1)-(ROUNDDOWN((COLUMN(E1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":11},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(F1)),COLUMN(F1)-(ROUNDDOWN((COLUMN(F1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":10},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(G1)),COLUMN(G1)-(ROUNDDOWN((COLUMN(G1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":14},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(H1)),COLUMN(H1)-(ROUNDDOWN((COLUMN(H1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":10},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(I1)),COLUMN(I1)-(ROUNDDOWN((COLUMN(I1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A2=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(J1)),COLUMN(J1)-(ROUNDDOWN((COLUMN(J1)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}}]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet3!$A$1:A2,Sheet1!$A$2:$A$6),0))","v":"orange"},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(A2)),COLUMN(A2)-(ROUNDDOWN((COLUMN(A2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":9},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(B2)),COLUMN(B2)-(ROUNDDOWN((COLUMN(B2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":9},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(C2)),COLUMN(C2)-(ROUNDDOWN((COLUMN(C2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(D2)),COLUMN(D2)-(ROUNDDOWN((COLUMN(D2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(E2)),COLUMN(E2)-(ROUNDDOWN((COLUMN(E2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(F2)),COLUMN(F2)-(ROUNDDOWN((COLUMN(F2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(G2)),COLUMN(G2)-(ROUNDDOWN((COLUMN(G2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(H2)),COLUMN(H2)-(ROUNDDOWN((COLUMN(H2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(I2)),COLUMN(I2)-(ROUNDDOWN((COLUMN(I2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A3=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(J2)),COLUMN(J2)-(ROUNDDOWN((COLUMN(J2)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}}]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet3!$A$1:A3,Sheet1!$A$2:$A$6),0))","v":"grapes"},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(A3)),COLUMN(A3)-(ROUNDDOWN((COLUMN(A3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":15},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(B3)),COLUMN(B3)-(ROUNDDOWN((COLUMN(B3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":15},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(C3)),COLUMN(C3)-(ROUNDDOWN((COLUMN(C3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":14},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(D3)),COLUMN(D3)-(ROUNDDOWN((COLUMN(D3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(E3)),COLUMN(E3)-(ROUNDDOWN((COLUMN(E3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(F3)),COLUMN(F3)-(ROUNDDOWN((COLUMN(F3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(G3)),COLUMN(G3)-(ROUNDDOWN((COLUMN(G3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(H3)),COLUMN(H3)-(ROUNDDOWN((COLUMN(H3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(I3)),COLUMN(I3)-(ROUNDDOWN((COLUMN(I3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}},{"$f":"INDEX(tbl,SMALL(IF($A4=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(J3)),COLUMN(J3)-(ROUNDDOWN((COLUMN(J3)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#NUM!"}}]
[{"$f":"INDEX(Sheet1!$A$2:$A$6,MATCH(0,COUNTIF(Sheet3!$A$1:A4,Sheet1!$A$2:$A$6),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(A4)),COLUMN(A4)-(ROUNDDOWN((COLUMN(A4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(B4)),COLUMN(B4)-(ROUNDDOWN((COLUMN(B4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(C4)),COLUMN(C4)-(ROUNDDOWN((COLUMN(C4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(D4)),COLUMN(D4)-(ROUNDDOWN((COLUMN(D4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(E4)),COLUMN(E4)-(ROUNDDOWN((COLUMN(E4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(F4)),COLUMN(F4)-(ROUNDDOWN((COLUMN(F4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(G4)),COLUMN(G4)-(ROUNDDOWN((COLUMN(G4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(H4)),COLUMN(H4)-(ROUNDDOWN((COLUMN(H4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(I4)),COLUMN(I4)-(ROUNDDOWN((COLUMN(I4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}},{"$f":"INDEX(tbl,SMALL(IF($A5=unique,IF(tbl,ROW(tbl)-MIN(ROW(tbl))+1,\"\"),\"\"),COLUMN(J4)),COLUMN(J4)-(ROUNDDOWN((COLUMN(J4)-1)/COLUMNS(tbl),0))*COLUMNS(tbl))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
["File downloaded from:",null,null,"Merge matching rows"]
["My excel site: ",null,null,"Get Digital Help"]
["RSS feed:",null,null,"RSS"]
["Newsletter:",null,null,"Newsletter"]