{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Лист1","Лист2","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Лист1","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["то, что имеем",null,null,null,"то, что хотелось бы иметь"]
["Артикул","Бренд","Коллекция"]
["AV_10088-1B","Россия","Адажио",null,"AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,{"$f":"Art(ROW()-2,$A$3:$C$17)","v":"AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T"}]
["AV_10087-3N","Россия","Адажио",null,"AV_10088-1B,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,{"$f":"Art(ROW()-2,$A$3:$C$17)","v":"AV_10088-1B,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T"}]
["AV_10086-3L","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T"]
["AV_10087-3L","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T"]
["AV_10088-3L","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10086-3T,AV_10087-3T,AV_10088-3T"]
["AV_10086-3T","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10087-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10087-3T,AV_10088-3T"]
["AV_10087-3T","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10088-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10088-3T"]
["AV_10088-3T","Россия","Адажио",null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T",null,null,null,null,null,null,null,null,null,"AV_10088-1B,AV_10087-3N,AV_10086-3L,AV_10087-3L,AV_10088-3L,AV_10086-3T,AV_10087-3T"]
["10025-2B","Китай","Ажур",null,"10025-3L,10025-3T",null,null,null,null,null,null,null,null,null,"10025-3L,10025-3T"]
["10025-3L","Китай","Ажур",null,"10025-2B,10025-3T",null,null,null,null,null,null,null,null,null,"10025-2B,10025-3T"]
["10025-3T","Китай","Ажур",null,"10025-2B,10025-3L",null,null,null,null,null,null,null,null,null,"10025-2B,10025-3L"]
["15-15","Германия","Айвенго",null,"15-16,15-17",null,null,null,null,null,null,null,null,null,"15-16,15-17"]
["15-16","Германия","Айвенго",null,"15-15,15-17",null,null,null,null,null,null,null,null,null,"15-15,15-17"]
["15-17","Германия","Айвенго",null,"15-15,15-16",null,null,null,null,null,null,null,null,null,"15-15,15-16"]
["AV_10138-5L","Россия","Амстердам"]
[]
["если в столбце \"Бренд\" одинаковые значения, то проверяем значение столбца \"Коллекция\", далее, если значения в столбце \"Коллекция\" совпадают, то транспортируем значения из столбца\"Артикул\"  в одну ячейку через запятую, при этом не транспортируем значение из ячейки \"Артикул\" этой же строки"]

{"sheet":"Лист2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}