{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","CONCATENATE","TEXTJOIN","Manually","Find & Replace","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":"Overview","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Make Comma Separated List "]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple",{"$f":"\"'\"&B5&\"'\"&\",\"&\"'\"&B6&\"'\"&\",\"&\"'\"&B7&\"'\"&\",\"&\"'\"&B8&\"'\"&\",\"&\"'\"&B9&\"'\"","v":"'Apple','Orange','Lemon','Pineapple','Banana'"}]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]

{"sheet":"CONCATENATE","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Make Comma Separated List Using CONCATENATE Function"]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple",{"$f":"CONCATENATE(B5,\",\",\" \",B6,\",\",\" \",B7,\",\",\" \",B8,\",\",\" \",B9)","v":"Apple, Orange, Lemon, Pineapple, Banana"}]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]

{"sheet":"TEXTJOIN","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Apply TEXTJOIN Function to Make Comma Separated List "]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple",{"$f":"_xlfn.TEXTJOIN(\",\", TRUE, B5:B9)","v":"Apple,Orange,Lemon,Pineapple,Banana"}]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]

{"sheet":"Manually","index":3,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Manually Make a Comma Separated List "]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple",{"$f":"B5&\"\"&\",\"&\"\"&B6&\"\"&\",\"&\"\"&B7&\"\"&\",\"&\"\"&B8&\"\"&\",\"&\"\"&B9","v":"Apple,Orange,Lemon,Pineapple,Banana"}]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]

{"sheet":"Find & Replace","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use Find & Replace to Make Comma Separated List "]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple"]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Run a VBA Code to Make Comma Separated List "]
[]
[null,"Fruit","Comma Separated List"]
[null,"Apple",{"$f":"ColumntoList(B5:B9)","v":"'Apple','Orange','Lemon','Pineapple','Banana'"}]
[null,"Orange"]
[null,"Lemon"]
[null,"Pineapple"]
[null,"Banana"]