{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sample Dataset","Formula-1","Formula-2","Formula-3","VBA","PowerQuery","PQoutput"],"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":"Sample Dataset","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Group-1","Group-2","Group-3"]
[null,"Damien","Jackob","Nick"]
[null,"Chris","Tom","Rose"]
[null,"Martin","Harry","Peter"]
[null,"James","Ron","George"]

{"sheet":"Formula-1","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Group-1","Group-2","Group-3",null,"All"]
[null,"Damien","Jackob","Nick",null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B5)-5)/COLUMNS($B$5:$D$8)),\nMOD(ROW(B5)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Damien"}]
[null,"Chris","Tom","Rose",null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B6)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B6)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Jackob"}]
[null,"Martin","Harry","Peter",null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B7)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B7)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Nick"}]
[null,"James","Ron","George",null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B8)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B8)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Chris"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B9)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B9)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Tom"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B10)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B10)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Rose"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B11)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B11)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Martin"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B12)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B12)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Harry"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B13)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B13)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Peter"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B14)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B14)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"James"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B15)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B15)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"Ron"}]
[null,null,null,null,null,{"$f":"INDEX($B$5:$D$8,1+INT((ROW(B16)-5)/COLUMNS($B$5:$D$8)),MOD(ROW(B16)-5+COLUMNS($B$5:$D$8),COLUMNS($B$5:$D$8))+1)","v":"George"}]

{"sheet":"Formula-2","index":2,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Group-1","Group-2","Group-3",null,"All"]
[null,"Damien","Jackob","Nick",null,{"$f":"OFFSET($B$4,CEILING((ROW(B5)-4)/COLUMNS($B$5:$D$8),1),\nMOD(ROW($B5)+COLUMNS($B$5:$D$8)-2,3))","v":"Damien"}]
[null,"Chris","Tom","Rose",null,{"$f":"OFFSET($B$4,CEILING((ROW(B6)-4)/COLUMNS($B$5:$D$8),1),MOD(ROW($B6)+COLUMNS($B$5:$D$8)-2,3))","v":"Jackob"}]
[null,"Martin","Harry","Peter",null,"Nick"]
[null,"James","Ron","George",null,"Chris"]
[null,null,null,null,null,"Tom"]
[null,null,null,null,null,"Rose"]
[null,null,null,null,null,"Martin"]
[null,null,null,null,null,"Harry"]
[null,null,null,null,null,"Peter"]
[null,null,null,null,null,"James"]
[null,null,null,null,null,"Ron"]
[null,null,null,null,null,"George"]

{"sheet":"Formula-3","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Group-1","Group-2","Group-3",null,"All"]
[null,"Damien","Jackob","Nick",null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:5)/3,0),MOD(ROWS($5:5)-1,3))","v":"Damien"}]
[null,"Chris","Tom","Rose",null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:6)/3,0),MOD(ROWS($5:6)-1,3))","v":"Jackob"}]
[null,"Martin","Harry","Peter",null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:7)/3,0),MOD(ROWS($5:7)-1,3))","v":"Nick"}]
[null,"James","Ron","George",null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:8)/3,0),MOD(ROWS($5:8)-1,3))","v":"Chris"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:9)/3,0),MOD(ROWS($5:9)-1,3))","v":"Tom"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:10)/3,0),MOD(ROWS($5:10)-1,3))","v":"Rose"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:11)/3,0),MOD(ROWS($5:11)-1,3))","v":"Martin"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:12)/3,0),MOD(ROWS($5:12)-1,3))","v":"Harry"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:13)/3,0),MOD(ROWS($5:13)-1,3))","v":"Peter"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:14)/3,0),MOD(ROWS($5:14)-1,3))","v":"James"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:15)/3,0),MOD(ROWS($5:15)-1,3))","v":"Ron"}]
[null,null,null,null,null,{"$f":"OFFSET($B$4,ROUNDUP(ROWS($5:16)/3,0),MOD(ROWS($5:16)-1,3))","v":"George"}]

{"sheet":"VBA","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Group-1","Group-2","Group-3",null,"All"]
[null,"Damien","Jackob","Nick",null,"Damien"]
[null,"Chris","Tom","Rose",null,"Jackob"]
[null,"Martin","Harry","Peter",null,"Nick"]
[null,"James","Ron","George",null,"Chris"]
[null,null,null,null,null,"Tom"]
[null,null,null,null,null,"Rose"]
[null,null,null,null,null,"Martin"]
[null,null,null,null,null,"Harry"]
[null,null,null,null,null,"Peter"]
[null,null,null,null,null,"James"]
[null,null,null,null,null,"Ron"]
[null,null,null,null,null,"George"]

{"sheet":"PowerQuery","index":5,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Transpose Multiple Columns into One"]
[]
[null,"Product","32 inches","34 inches","36 inches","38 inches"]
[null,"Shirt",11,36,36,30]
[null,"Pant",34,28,16,32]
[null,"Blouse",43,37,33,14]
[null,"T-shirt",12,41,17,34]

{"sheet":"PQoutput","index":6,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Product","Size","Quantity"]
["Shirt","32 inches",11]
["Shirt","34 inches",36]
["Shirt","36 inches",36]
["Shirt","38 inches",30]
["Pant","32 inches",34]
["Pant","34 inches",28]
["Pant","36 inches",16]
["Pant","38 inches",32]
["Blouse","32 inches",43]
["Blouse","34 inches",37]
["Blouse","36 inches",33]
["Blouse","38 inches",14]
["T-shirt","32 inches",12]
["T-shirt","34 inches",41]
["T-shirt","36 inches",17]
["T-shirt","38 inches",34]