{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Main Dataset","TOCOL Function","Using OFFSET ","INDEX Function ","FILTERXML & TEXTJOIN Functions","TRANSPOSE Function","Paste Special Feature","VBA Code"],"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":"Main Dataset","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Converting Multiple Rows to Single Column"]
[]
[null,"Team Red","Jack","Rose","Lily"]
[null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John"]

{"sheet":"TOCOL Function","index":1,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Use of TOCOL Function",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,{"$f":"_xlfn.TOCOL(C4:E6)","v":"Jack"},null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,"Rose",null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,"Lily"]
[null,null,null,null,null,null,"Joe"]
[null,null,null,null,null,null,"Bella"]
[null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,"Megh"]
[null,null,null,null,null,null,"Peter"]
[null,null,null,null,null,null,"John"]

{"sheet":"Using OFFSET ","index":2,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Using OFFSET, ROUNDUP, ROWS & MOD Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:1)/3,0)-1,MOD(ROWS($1:1)-1,3))","v":"Jack"},null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:2)/3,0)-1,MOD(ROWS($1:2)-1,3))","v":"Rose"},null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:3)/3,0)-1,MOD(ROWS($1:3)-1,3))","v":"Lily"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:4)/3,0)-1,MOD(ROWS($1:4)-1,3))","v":"Joe"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:5)/3,0)-1,MOD(ROWS($1:5)-1,3))","v":"Bella"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:6)/3,0)-1,MOD(ROWS($1:6)-1,3))","v":"Harry"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:7)/3,0)-1,MOD(ROWS($1:7)-1,3))","v":"Megh"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:8)/3,0)-1,MOD(ROWS($1:8)-1,3))","v":"Peter"}]
[null,null,null,null,null,null,{"$f":"OFFSET($C$4,ROUNDUP(ROWS($1:9)/3,0)-1,MOD(ROWS($1:9)-1,3))","v":"John"}]

{"sheet":"INDEX Function ","index":3,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Use of Combined Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C1)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C1)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Jack"},null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C2)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C2)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Rose"},null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C3)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C3)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Lily"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C4)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C4)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Joe"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C5)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C5)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Bella"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C6)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C6)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Harry"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C7)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C7)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Megh"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C8)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C8)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"Peter"}]
[null,null,null,null,null,null,{"$f":"INDEX($C$4:$E$6,1+INT((ROW(C9)-1)/COLUMNS($C$4:$E$6)),MOD(ROW(C9)-1+COLUMNS($C$4:$E$6),COLUMNS($C$4:$E$6))+1)","v":"John"}]

{"sheet":"FILTERXML & TEXTJOIN Functions","index":4,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Combination of FILTERXML & TEXTJOIN Functions",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,{"$f":"_xlfn.FILTERXML(\"<r><n>\" & _xlfn.TEXTJOIN(\"</n><n>\",,C4:E6) & \"</n></r>\",\"//n\")","v":"Jack"},null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,"Rose",null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,"Lily"]
[null,null,null,null,null,null,"Joe"]
[null,null,null,null,null,null,"Bella"]
[null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,"Megh"]
[null,null,null,null,null,null,"Peter"]
[null,null,null,null,null,null,"John"]

{"sheet":"TRANSPOSE Function","index":5,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Use of TRANSPOSE Function",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,{"$f":"TRANSPOSE(C4:E4)","v":"Jack"},null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,"Rose",null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,"Lily"]
[null,null,null,null,null,null,{"$f":"TRANSPOSE(C5:E5)","v":"Joe"}]
[null,null,null,null,null,null,"Bella"]
[null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,{"$f":"TRANSPOSE(C6:E6)","v":"Megh"}]
[null,null,null,null,null,null,"Peter"]
[null,null,null,null,null,null,"John"]

{"sheet":"Paste Special Feature","index":6,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Applying Paste Special Feature",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,"Jack",null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,"Rose",null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,"Lily"]
[null,null,null,null,null,null,"Joe"]
[null,null,null,null,null,null,"Bella"]
[null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,"Megh"]
[null,null,null,null,null,null,"Peter"]
[null,null,null,null,null,null,"John"]

{"sheet":"VBA Code","index":7,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,12,1,17]]}
[]
[null,"Employing VBA Code",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Team Red","Jack","Rose","Lily",null,"All Players",null,null,null,null,null,"Team Red","Jack","Rose","Lily",null,"All Players"]
[null,"Team Blue","Joe","Bella","Harry",null,"Jack",null,null,null,null,null,"Team Blue","Joe","Bella","Harry"]
[null,"Team Green","Megh","Peter","John",null,"Rose",null,null,null,null,null,"Team Green","Megh","Peter","John"]
[null,null,null,null,null,null,"Lily"]
[null,null,null,null,null,null,"Joe"]
[null,null,null,null,null,null,"Bella"]
[null,null,null,null,null,null,"Harry"]
[null,null,null,null,null,null,"Megh"]
[null,null,null,null,null,null,"Peter"]
[null,null,null,null,null,null,"John"]