{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Raw data"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Raw data","index":0,"n_rows":113,"n_cols":15,"rows_kept":113,"cut":false,"hidden":false,"merged":[[46,11,56,11],[46,12,56,12],[3,9,60,9],[3,10,60,10],[3,11,12,11],[3,12,12,12],[13,11,13,14],[14,11,19,11],[14,12,19,12],[20,11,20,14],[21,11,27,11],[21,12,27,12],[29,11,35,11],[29,12,35,12],[37,11,44,11],[37,12,44,12],[45,11,45,14],[62,9,111,9],[62,10,111,10],[62,11,67,11],[62,12,67,12],[68,11,68,14],[57,11,57,14],[58,11,59,11],[58,12,59,12],[60,11,60,14],[61,9,61,14],[89,12,96,12],[69,11,72,11],[69,12,72,12],[73,11,73,14],[74,11,79,11],[74,12,79,12],[80,11,80,14],[111,11,111,14],[4,7,11,7],[14,7,17,7],[0,9,0,14],[0,0,0,5],[97,11,97,14],[98,11,105,11],[98,12,105,12],[106,11,106,14],[107,11,110,11],[107,12,110,12],[81,11,85,11],[81,12,85,12],[86,11,86,14],[88,11,88,14],[89,11,96,11]]}
["Raw data before applying macro",null,null,null,null,null,null,null,null,"After working via macro"]
[]
["Shift","Person name","Sub Shift","Sub person Name","Number","Name",null,null,null,"Shift","Person name","Sub Shift","Sub person Name","Number","Name"]
[11,"ABC",11,"ABC12",1,"af",null,null,null,11,"ABC",11,"ABC12",1,"af"]
[null,null,null,null,2,"f","<-------","This is a raw data & I want to mearge the cell those are blank",null,null,null,null,null,2,"f"]
[null,null,null,null,4,"sbs",null,null,null,null,null,null,null,4,"sbs"]
[null,null,null,null,5,"dg",null,null,null,null,null,null,null,5,"dg"]
[null,null,null,null,8,"adhg",null,null,null,null,null,null,null,8,"adhg"]
[null,null,null,null,10,"adg",null,null,null,null,null,null,null,10,"adg"]
[null,null,null,null,11,"adg",null,null,null,null,null,null,null,11,"adg"]
[null,null,null,null,12,"adhg",null,null,null,null,null,null,null,12,"adhg"]
[null,null,null,null,13,"ag",null,null,null,null,null,null,null,13,"ag"]
[null,null,null,null,32,"fhdf",null,null,null,null,null,null,null,32,"fhdf"]
[null,null,"11 Total",null,null,null,null,null,null,null,null,"11 Total"]
[null,null,12,"abc13",1,"adg",null,"Result will like"," -------->",null,null,12,"abc13",1,"adg"]
[null,null,null,null,2,"adhg",null,null,null,null,null,null,null,2,"adhg"]
[null,null,null,null,4,"ag",null,null,null,null,null,null,null,4,"ag"]
[null,null,null,null,5,"fhdf",null,null,null,null,null,null,null,5,"fhdf"]
[null,null,null,null,10,"dg",null,null,null,null,null,null,null,10,"dg"]
[null,null,null,null,11,"utru",null,null,null,null,null,null,null,11,"utru"]
[null,null,"12 Total",null,null,null,null,null,null,null,null,"12 Total"]
[null,null,13,"abc14",1,"adhg",null,null,null,null,null,13,"abc14",1,"adhg"]
[null,null,null,null,2,"adhg",null,null,null,null,null,null,null,2,"adhg"]
[null,null,null,null,4,"adhg",null,null,null,null,null,null,null,4,"adhg"]
[null,null,null,null,5,"adhg",null,null,null,null,null,null,null,5,"adhg"]
[null,null,null,null,10,"adhg",null,null,null,null,null,null,null,10,"adhg"]
[null,null,null,null,11,"adhg",null,null,null,null,null,null,null,11,"adhg"]
[null,null,null,null,12,"adhg",null,null,null,null,null,null,null,12,"adhg"]
[null,null,"13 Total",null,null,null,null,null,null,null,null,"13 Total"]
[null,null,14,"abc15",1,"adhg",null,null,null,null,null,14,"abc15",1,"adhg"]
[null,null,null,null,2,"adhg",null,null,null,null,null,null,null,2,"adhg"]
[null,null,null,null,4,"adhg",null,null,null,null,null,null,null,4,"adhg"]
[null,null,null,null,5,"adhg",null,null,null,null,null,null,null,5,"adhg"]
[null,null,null,null,10,"adhg",null,null,null,null,null,null,null,10,"adhg"]
[null,null,null,null,11,"adhg",null,null,null,null,null,null,null,11,"adhg"]
[null,null,null,null,12,"adhg",null,null,null,null,null,null,null,12,"adhg"]
[null,null,"14 Total",null,null,null,null,null,null,null,null,"14 Total"]
[null,null,15,"abc16",1,"adhg",null,null,null,null,null,15,"abc16",1,"adhg"]
[null,null,null,null,3,"adhg",null,null,null,null,null,null,null,3,"adhg"]
[null,null,null,null,4,"adhg",null,null,null,null,null,null,null,4,"adhg"]
[null,null,null,null,5,"adhg",null,null,null,null,null,null,null,5,"adhg"]
[null,null,null,null,6,"adhg",null,null,null,null,null,null,null,6,"adhg"]
[null,null,null,null,7,"adhg",null,null,null,null,null,null,null,7,"adhg"]
[null,null,null,null,13,"adhg",null,null,null,null,null,null,null,13,"adhg"]
[null,null,null,null,32,"adhg",null,null,null,null,null,null,null,32,"adhg"]
[null,null,"15 Total",null,null,null,null,null,null,null,null,"15 Total"]
[null,null,16,"abc17",1,"czb",null,null,null,null,null,16,"abc17",1,"czb"]
[null,null,null,null,3,"czb",null,null,null,null,null,null,null,3,"czb"]
[null,null,null,null,4,"czb",null,null,null,null,null,null,null,4,"czb"]
[null,null,null,null,5,"czb",null,null,null,null,null,null,null,5,"czb"]
[null,null,null,null,6,"czb",null,null,null,null,null,null,null,6,"czb"]
[null,null,null,null,7,"czb",null,null,null,null,null,null,null,7,"czb"]
[null,null,null,null,8,"czb",null,null,null,null,null,null,null,8,"czb"]
[null,null,null,null,9,"czb",null,null,null,null,null,null,null,9,"czb"]
[null,null,null,null,10,"czb",null,null,null,null,null,null,null,10,"czb"]
[null,null,null,null,14,"czb",null,null,null,null,null,null,null,14,"czb"]
[null,null,null,null,32,"czb",null,null,null,null,null,null,null,32,"czb"]
[null,null,"16 Total",null,null,null,null,null,null,null,null,"16 Total"]
[null,null,18,"abc18",4,"yamaha",null,null,null,null,null,18,"abc18",4,"yamaha"]
[null,null,null,null,7,"yamaha",null,null,null,null,null,null,null,7,"yamaha"]
[null,null,"18 Total",null,null,null,null,null,null,null,null,"18 Total"]
["11 Total",null,null,null,null,null,null,null,null,"11 Total"]
[12,"asd",11,"abc19",1,"Honda",null,null,null,12,"asd",11,"abc19",1,"Honda"]
[null,null,null,null,2,"Honda",null,null,null,null,null,null,null,2,"Honda"]
[null,null,null,null,4,"Honda",null,null,null,null,null,null,null,4,"Honda"]
[null,null,null,null,5,"Honda",null,null,null,null,null,null,null,5,"Honda"]
[null,null,null,null,8,"Honda",null,null,null,null,null,null,null,8,"Honda"]
[null,null,null,null,32,"Honda",null,null,null,null,null,null,null,32,"Honda"]
[null,null,"11 Total",null,null,null,null,null,null,null,null,"11 Total"]
[null,null,12,"abc20",1,"Activa",null,null,null,null,null,12,"abc20",1,"Activa"]
[null,null,null,null,2,"Activa",null,null,null,null,null,null,null,2,"Activa"]
[null,null,null,null,4,"Activa",null,null,null,null,null,null,null,4,"Activa"]
[null,null,null,null,5,"Activa",null,null,null,null,null,null,null,5,"Activa"]
[null,null,"12 Total",null,null,null,null,null,null,null,null,"12 Total"]
[null,null,13,"abc21",1,"gjgf",null,null,null,null,null,13,"abc21",1,"gjgf"]
[null,null,null,null,2,"gjgf",null,null,null,null,null,null,null,2,"gjgf"]
[null,null,null,null,4,"gjgf",null,null,null,null,null,null,null,4,"gjgf"]
[null,null,null,null,5,"gjgf",null,null,null,null,null,null,null,5,"gjgf"]
[null,null,null,null,10,"gjgf",null,null,null,null,null,null,null,10,"gjgf"]
[null,null,null,null,12,"gjgf",null,null,null,null,null,null,null,12,"gjgf"]
[null,null,"13 Total",null,null,null,null,null,null,null,null,"13 Total"]
[null,null,14,"abc22",1,"gjgf",null,null,null,null,null,14,"abc22",1,"gjgf"]
[null,null,null,null,2,"gjgf",null,null,null,null,null,null,null,2,"gjgf"]
[null,null,null,null,4,"gjgf",null,null,null,null,null,null,null,4,"gjgf"]
[null,null,null,null,5,"gjgf",null,null,null,null,null,null,null,5,"gjgf"]
[null,null,null,null,12,"gjgf",null,null,null,null,null,null,null,12,"gjgf"]
[null,null,"14 Total",null,null,null,null,null,null,null,null,"14 Total"]
[null,null,15,"abc23",7,"fb",null,null,null,null,null,15,"abc23",7,"fb"]
[null,null,"15 Total",null,null,null,null,null,null,null,null,"15 Total"]
[null,null,16,"abc24",1,"T-",null,null,null,null,null,16,"abc24",1,"T-"]
[null,null,null,null,4,"T-",null,null,null,null,null,null,null,4,"T-"]
[null,null,null,null,5,"T-",null,null,null,null,null,null,null,5,"T-"]
[null,null,null,null,6,"T-",null,null,null,null,null,null,null,6,"T-"]
[null,null,null,null,7,"T-",null,null,null,null,null,null,null,7,"T-"]
[null,null,null,null,13,"T-",null,null,null,null,null,null,null,13,"T-"]
[null,null,null,null,14,"T-",null,null,null,null,null,null,null,14,"T-"]
[null,null,null,null,32,"T-",null,null,null,null,null,null,null,32,"T-"]
[null,null,"16 Total",null,null,null,null,null,null,null,null,"16 Total"]
[null,null,17,"abc25",1,"Sets",null,null,null,null,null,17,"abc25",1,"Coffee"]
[null,null,null,null,3,"Sets",null,null,null,null,null,null,null,3,"Coffee"]
[null,null,null,null,4,"Sets",null,null,null,null,null,null,null,4,"Coffee"]
[null,null,null,null,6,"Sets",null,null,null,null,null,null,null,6,"Coffee"]
[null,null,null,null,7,"Sets",null,null,null,null,null,null,null,7,"Coffee"]
[null,null,null,null,8,"Sets",null,null,null,null,null,null,null,8,"Coffee"]
[null,null,null,null,13,"Sets",null,null,null,null,null,null,null,13,"Coffee"]
[null,null,null,null,14,"Sets",null,null,null,null,null,null,null,14,"Coffee"]
[null,null,"17 Total",null,null,null,null,null,null,null,null,"17 Total"]
[null,null,18,"abc26",1,"Dress",null,null,null,null,null,18,"abc26",1,"d"]
[null,null,null,null,3,"Dress",null,null,null,null,null,null,null,3,"d"]
[null,null,null,null,4,"Dress",null,null,null,null,null,null,null,4,"d"]
[null,null,null,null,7,"Dress",null,null,null,null,null,null,null,7,"d"]
[null,null,"18 Total",null,null,null,null,null,null,null,null,"18 Total"]
["12 Total",null,null,null,null,null,null,null,null,"12 Total"]