{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Power Query","Power Query (2)","Combined Functions","Combinations of Functions","VBA"],"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":"Power Query","index":0,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Power Query",null,null,null,"Do Yourself"]
[]
[null,"Gender",null,"Category",null,"Gender",null,"Category"]
[null,"Male",null,"Jacket",null,"Male",null,"Jacket"]
[null,"Female",null,"Jeans",null,"Female",null,"Jeans"]
[null,null,null,"Sweaters",null,null,null,"Sweaters"]

{"sheet":"Power Query (2)","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query"]
[]
[null,"Gender","Custom.Category","Products"]
[null,"Male","Jacket","Male-Jacket"]
[null,"Male","Jeans","Male-Jeans"]
[null,"Male","Sweaters","Male-Sweaters"]
[null,"Female","Jacket","Female-Jacket"]
[null,"Female","Jeans","Female-Jeans"]
[null,"Female","Sweaters","Female-Sweaters"]

{"sheet":"Combined Functions","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying Combined Functions",null,null,null,"Do Yourself"]
[]
[null,"Gender","Category","Products",null,"Gender","Category","Products"]
[null,"Male","Jacket",{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\", INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&\"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Male-Jacket"},null,"Male","Jacket"]
[null,"Female","Jeans",{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",                                                                                                                                                                                                                            INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&                                                                                                                                                                                                                                         \"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Male-Jeans"},null,"Female","Jeans"]
[null,null,"Sweaters",{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",                                                                                                                                                                                                                            INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&                                                                                                                                                                                                                                         \"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Male-Sweaters"},null,null,"Sweaters"]
[null,null,null,{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",                                                                                                                                                                                                                            INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&                                                                                                                                                                                                                                         \"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Female-Jacket"}]
[null,null,null,{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",                                                                                                                                                                                                                            INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&                                                                                                                                                                                                                                         \"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Female-Jeans"}]
[null,null,null,{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",                                                                                                                                                                                                                            INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&                                                                                                                                                                                                                                         \"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":"Female-Sweaters"}]
[null,null,null,{"$f":"IF(ROW()-ROW($D$5)+1>COUNTA($B$5:$B$6)*COUNTA($C$5:$C$7),\"\",INDEX($B$5:$B$6,INT((ROW()-ROW($D$5))/COUNTA($C$5:$C$7)+1))&\"-\"&INDEX($C$5:$C$7,MOD(ROW()-ROW($D$5),COUNTA($C$5:$C$7))+1))","v":""}]

{"sheet":"Combinations of Functions","index":3,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,8],[1,10,1,17]]}
[]
[null,"Using Helper Columns and Combined Functions",null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Gender","Category",null,"Gender Row","Category Row","Gender","Category","Products",null,"Gender","Category",null,"Gender Row","Category Row","Gender","Category","Products"]
[null,"Male","Jacket",null,{"$f":"QUOTIENT(ROW(E5)-4,$C$10)+IF(MOD(ROW(E5)-4,$C$10)=0,0,1)","v":1},{"$f":"COUNTIF($E$5:E5,E5)","v":1},{"$f":"INDEX($B$5:$B$6,E5)","v":"Male"},{"$f":"INDEX($C$5:$C$7,F5)","v":"Jacket"},{"$f":"CONCATENATE(G5,\"-\",H5)","v":"Male-Jacket"},null,"Male","Jacket"]
[null,"Female","Jeans",null,{"$f":"QUOTIENT(ROW(E6)-4,$C$10)+IF(MOD(ROW(E6)-4,$C$10)=0,0,1)","v":1},{"$f":"COUNTIF($E$5:E6,E6)","v":2},{"$f":"INDEX($B$5:$B$6,E6)","v":"Male"},{"$f":"INDEX($C$5:$C$7,F6)","v":"Jeans"},{"$f":"CONCATENATE(G6,\"-\",H6)","v":"Male-Jeans"},null,"Female","Jeans"]
[null,null,"Sweaters",null,1,{"$f":"COUNTIF($E$5:E7,E7)","v":3},{"$f":"INDEX($B$5:$B$6,E7)","v":"Male"},{"$f":"INDEX($C$5:$C$7,F7)","v":"Sweaters"},"Male-Sweaters",null,null,"Sweaters"]
[null,null,null,null,2,{"$f":"COUNTIF($E$5:E8,E8)","v":1},{"$f":"INDEX($B$5:$B$6,E8)","v":"Female"},{"$f":"INDEX($C$5:$C$7,F8)","v":"Jacket"},"Female-Jacket"]
[null,"Gender",{"$f":"COUNTA(B5:B6)","v":2},null,2,{"$f":"COUNTIF($E$5:E9,E9)","v":2},{"$f":"INDEX($B$5:$B$6,E9)","v":"Female"},{"$f":"INDEX($C$5:$C$7,F9)","v":"Jeans"},"Female-Jeans",null,"Gender"]
[null,"Category",{"$f":"COUNTA(C5:C7)","v":3},null,2,{"$f":"COUNTIF($E$5:E10,E10)","v":3},{"$f":"INDEX($B$5:$B$6,E10)","v":"Female"},{"$f":"INDEX($C$5:$C$7,F10)","v":"Sweaters"},"Female-Sweaters",null,"Category"]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Applying VBA Code",null,null,null,"Do Yourself"]
[]
[null,"Gender","Category","Products",null,"Gender","Category","Products"]
[null,"Male","Jacket","Male-Jacket",null,"Male","Jacket"]
[null,"Female","Jeans","Male-Jeans",null,"Female","Jeans"]
[null,null,"Sweaters","Male-Sweaters",null,null,"Sweaters"]
[null,null,null,"Female-Jacket"]
[null,null,null,"Female-Jeans"]
[null,null,null,"Female-Sweaters"]