{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset-1","Using UNIQUE & TEXTJOIN ","Applying IF Function and Sort","Dataset-2","Utilizing Consolidate Option_x0009__x0009__x0009_","Applying VBA Code_x0009_"],"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":"Dataset-1","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Country","City"]
[null,"USA","Austin"]
[null,"England","London"]
[null,"USA","Seattle"]
[null,"India","Mumbai"]
[null,"England","Manchester"]
[null,"India","Delhi"]
[null,"India","Bangalore"]
[null,"England","Southampton"]
[null,"USA","Chicago"]

{"sheet":"Using UNIQUE & TEXTJOIN ","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,11]]}
[]
[null,"Using UNIQUE and TEXTJOIN Funtions",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Country","City",null,"Country","City",null,null,null,null,"Country","City"]
[null,"USA","Austin",null,{"$f":"_xlfn.UNIQUE(B5:B13)","v":"USA"},{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF(E5=B5:B13,C5:C13,\"\"))","v":"Austin,Seattle,Chicago"}]
[null,"England","London",null,"England",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF(E6=B6:B14,C6:C14,\"\"))","v":"London,Manchester,Southampton"}]
[null,"USA","Seattle",null,"India",{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,IF(E7=B7:B15,C7:C15,\"\"))","v":"Mumbai,Delhi,Bangalore"}]
[null,"India","Mumbai"]
[null,"England","Manchester"]
[null,"India","Delhi"]
[null,"India","Bangalore"]
[null,"England","Southampton"]
[null,"USA","Chicago"]

{"sheet":"Applying IF Function and Sort","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Applying IF Function and Sort",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Country","City","Cities","Final Sort",null,null,null,null,null,"Country","City","Cities","Final Sort"]
[null,"England","Southampton","London,Manchester,Southampton","Final Row",null,null,null,null,null,"England","Southampton"]
[null,"India","Bangalore","Mumbai,Delhi,Bangalore","Final Row",null,null,null,null,null,"India","Bangalore"]
[null,"USA","Chicago","Austin,Seattle,Chicago","Final Row",null,null,null,null,null,"USA","Chicago"]
[null,"England","London","London","",null,null,null,null,null,"England","London",null,""]
[null,"England","Manchester","London,Manchester","",null,null,null,null,null,"England","Manchester",null,""]
[null,"India","Mumbai","Mumbai","",null,null,null,null,null,"India","Mumbai",null,""]
[null,"India","Delhi","Mumbai,Delhi","",null,null,null,null,null,"India","Delhi",null,""]
[null,"USA","Austin","Austin","",null,null,null,null,null,"USA","Austin",null,""]
[null,"USA","Seattle","Austin,Seattle","",null,null,null,null,null,"USA","Seattle",null,""]

{"sheet":"Dataset-2","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Sales Person","Sales Amount"]
[null,"Adam",20]
[null,"Layla",80]
[null,"Chris",122]
[null,"Adam",46]
[null,"Chris",56]
[null,"John",20]
[null,"John",120]
[null,"Layla",60]
[null,"Adam",25]
[null,"Chris",75]

{"sheet":"Utilizing Consolidate Option_x0009__x0009__x0009_","index":4,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,13]]}
[]
[null,"Utilizing Consolidate Option",null,null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Sales Person","Sales Amount",null,"Sales Person","Total Sales Amount",null,null,null,null,null,null,"Sales Person","Total Sales Amount"]
[null,"Adam",20,null,"Adam",91]
[null,"Layla",80,null,"Layla",140]
[null,"Chris",122,null,"Chris",178]
[null,"Adam",46,null,"John",140]
[null,"Chris",56]
[null,"John",20]
[null,"John",120]
[null,"Layla",60]
[null,"Adam",25]
[null,"Chris",75]

{"sheet":"Applying VBA Code_x0009_","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA Code"]
[]
[null,"Sales Person","Sales Amount"]
[null,"Adam",91]
[null,"Layla",140]
[null,"Chris",253]
[null,"John",140]