{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Method 1.1","Method 1.2","Method 1.3","Method 2","Method 3.1","Method 3.2 ","Method 4","Method 5"],"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":"Method 1.1","index":0,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,13]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,"Fruits list","Olive","Papaya","Pineapple","Avocados","Jackfruit"]
[null,"Vendor Company","Rasmatan","Sailor","Fruity","Avos","Crazy Jack"]
[null,"Delivery Amount",100,45,37,95,82]
[null,"Delivery Date","2022-12-25","2022-12-18","2022-12-20","2022-12-24","2022-12-29"]

{"sheet":"Method 1.2","index":1,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,13]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,"Fruits list","Olive","Papaya","Pineapple","Avocados","Jackfruit"]
[null,"Vendor Company","Rasmatan","Sailor","Fruity","Avos","Crazy Jack"]
[null,"Delivery Amount",100,45,37,95,82]
[null,"Delivery Date","2022-12-25","2022-12-18","2022-12-20","2022-12-24","2022-12-29"]

{"sheet":"Method 1.3","index":2,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,13]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,"Fruits list","Olive","Papaya","Pineapple","Avocados","Jackfruit"]
[null,"Vendor Company","Rasmatan","Sailor","Fruity","Avos","Crazy Jack"]
[null,"Delivery Amount",100,45,37,95,82]
[null,"Delivery Date","2022-12-25","2022-12-18","2022-12-20","2022-12-24","2022-12-29"]

{"sheet":"Method 2","index":3,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,13]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,{"$f":"TRANSPOSE(B5:E10)","v":"Fruits list"},"Olive","Papaya","Pineapple","Avocados","Jackfruit"]
[null,"Vendor Company","Rasmatan","Sailor","Fruity","Avos","Crazy Jack"]
[null,"Delivery Amount",100,45,37,95,82]
[null,"Delivery Date",44920,44913,44915,44919,44924]

{"sheet":"Method 3.1","index":4,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,8,2,11]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Fruits list"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Olive"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Papaya"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Pineapple"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Avocados"},{"$f":"INDIRECT(\"B\"&COLUMN()+3)","v":"Jackfruit"}]
[null,{"$f":"INDIRECT(\"C\"&COLUMN()+3)","v":"Vendor Company"},{"$f":"INDIRECT(\"c\"&COLUMN()+3)","v":"Rasmatan"},{"$f":"INDIRECT(\"c\"&COLUMN()+3)","v":"Sailor"},{"$f":"INDIRECT(\"c\"&COLUMN()+3)","v":"Fruity"},{"$f":"INDIRECT(\"c\"&COLUMN()+3)","v":"Avos"},{"$f":"INDIRECT(\"c\"&COLUMN()+3)","v":"Crazy Jack"}]
[null,{"$f":"INDIRECT(\"D\"&COLUMN()+3)","v":"Delivery Amount"},{"$f":"INDIRECT(\"d\"&COLUMN()+3)","v":100},{"$f":"INDIRECT(\"d\"&COLUMN()+3)","v":45},{"$f":"INDIRECT(\"d\"&COLUMN()+3)","v":37},{"$f":"INDIRECT(\"d\"&COLUMN()+3)","v":95},{"$f":"INDIRECT(\"d\"&COLUMN()+3)","v":82}]
[null,{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":"Delivery Date"},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":44920},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":44913},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":44915},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":44919},{"$f":"INDIRECT(\"E\"&COLUMN()+3)","v":44924}]

{"sheet":"Method 3.2 ","index":5,"n_rows":16,"n_cols":14,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,10,2,13]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B5)-COLUMN($B$5)+ROW($B$5),ROW(B5)-ROW($B$5)+COLUMN($B$5)))","v":"Fruits list"},{"$f":"INDIRECT(ADDRESS(COLUMN(C5)-COLUMN($B$5)+ROW($B$5),ROW(C5)-ROW($B$5)+COLUMN($B$5)))","v":"Olive"},{"$f":"INDIRECT(ADDRESS(COLUMN(D5)-COLUMN($B$5)+ROW($B$5),ROW(D5)-ROW($B$5)+COLUMN($B$5)))","v":"Papaya"},{"$f":"INDIRECT(ADDRESS(COLUMN(E5)-COLUMN($B$5)+ROW($B$5),ROW(E5)-ROW($B$5)+COLUMN($B$5)))","v":"Pineapple"},{"$f":"INDIRECT(ADDRESS(COLUMN(F5)-COLUMN($B$5)+ROW($B$5),ROW(F5)-ROW($B$5)+COLUMN($B$5)))","v":"Avocados"},{"$f":"INDIRECT(ADDRESS(COLUMN(G5)-COLUMN($B$5)+ROW($B$5),ROW(G5)-ROW($B$5)+COLUMN($B$5)))","v":"Jackfruit"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B6)-COLUMN($B$5)+ROW($B$5),ROW(B6)-ROW($B$5)+COLUMN($B$5)))","v":"Vendor Company"},{"$f":"INDIRECT(ADDRESS(COLUMN(C6)-COLUMN($B$5)+ROW($B$5),ROW(C6)-ROW($B$5)+COLUMN($B$5)))","v":"Rasmatan"},{"$f":"INDIRECT(ADDRESS(COLUMN(D6)-COLUMN($B$5)+ROW($B$5),ROW(D6)-ROW($B$5)+COLUMN($B$5)))","v":"Sailor"},{"$f":"INDIRECT(ADDRESS(COLUMN(E6)-COLUMN($B$5)+ROW($B$5),ROW(E6)-ROW($B$5)+COLUMN($B$5)))","v":"Fruity"},{"$f":"INDIRECT(ADDRESS(COLUMN(F6)-COLUMN($B$5)+ROW($B$5),ROW(F6)-ROW($B$5)+COLUMN($B$5)))","v":"Avos"},{"$f":"INDIRECT(ADDRESS(COLUMN(G6)-COLUMN($B$5)+ROW($B$5),ROW(G6)-ROW($B$5)+COLUMN($B$5)))","v":"Crazy Jack"}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B7)-COLUMN($B$5)+ROW($B$5),ROW(B7)-ROW($B$5)+COLUMN($B$5)))","v":"Delivery Amount"},{"$f":"INDIRECT(ADDRESS(COLUMN(C7)-COLUMN($B$5)+ROW($B$5),ROW(C7)-ROW($B$5)+COLUMN($B$5)))","v":100},{"$f":"INDIRECT(ADDRESS(COLUMN(D7)-COLUMN($B$5)+ROW($B$5),ROW(D7)-ROW($B$5)+COLUMN($B$5)))","v":45},{"$f":"INDIRECT(ADDRESS(COLUMN(E7)-COLUMN($B$5)+ROW($B$5),ROW(E7)-ROW($B$5)+COLUMN($B$5)))","v":37},{"$f":"INDIRECT(ADDRESS(COLUMN(F7)-COLUMN($B$5)+ROW($B$5),ROW(F7)-ROW($B$5)+COLUMN($B$5)))","v":95},{"$f":"INDIRECT(ADDRESS(COLUMN(G7)-COLUMN($B$5)+ROW($B$5),ROW(G7)-ROW($B$5)+COLUMN($B$5)))","v":82}]
[null,{"$f":"INDIRECT(ADDRESS(COLUMN(B8)-COLUMN($B$5)+ROW($B$5),ROW(B8)-ROW($B$5)+COLUMN($B$5)))","v":"Delivery Date"},{"$f":"INDIRECT(ADDRESS(COLUMN(C8)-COLUMN($B$5)+ROW($B$5),ROW(C8)-ROW($B$5)+COLUMN($B$5)))","v":44920},{"$f":"INDIRECT(ADDRESS(COLUMN(D8)-COLUMN($B$5)+ROW($B$5),ROW(D8)-ROW($B$5)+COLUMN($B$5)))","v":44913},{"$f":"INDIRECT(ADDRESS(COLUMN(E8)-COLUMN($B$5)+ROW($B$5),ROW(E8)-ROW($B$5)+COLUMN($B$5)))","v":44915},{"$f":"INDIRECT(ADDRESS(COLUMN(F8)-COLUMN($B$5)+ROW($B$5),ROW(F8)-ROW($B$5)+COLUMN($B$5)))","v":44919},{"$f":"INDIRECT(ADDRESS(COLUMN(G8)-COLUMN($B$5)+ROW($B$5),ROW(G8)-ROW($B$5)+COLUMN($B$5)))","v":44924}]

{"sheet":"Method 4","index":6,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,8,2,11]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]

{"sheet":"Method 5","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,6],[2,9,2,12]]}
[]
[]
[null,"Transposing Multiple Rows in Group to Columns",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date",null,null,null,null,"Fruits list","Vendor Company","Delivery Amount","Delivery Date"]
[null,"Olive","Rasmatan",100,"2022-12-25",null,null,null,null,"Olive","Rasmatan",100,"2022-12-25"]
[null,"Papaya","Sailor",45,"2022-12-18",null,null,null,null,"Papaya","Sailor",45,"2022-12-18"]
[null,"Pineapple","Fruity",37,"2022-12-20",null,null,null,null,"Pineapple","Fruity",37,"2022-12-20"]
[null,"Avocados","Avos",95,"2022-12-24",null,null,null,null,"Avocados","Avos",95,"2022-12-24"]
[null,"Jackfruit","Crazy Jack",82,"2022-12-29",null,null,null,null,"Jackfruit","Crazy Jack",82,"2022-12-29"]
[]
[]
[null,"Fruits list","Olive","Papaya","Pineapple","Avocados","Jackfruit"]
[null,"Vendor Company","Rasmatan","Sailor","Fruity","Avos","Crazy Jack"]
[null,"Delivery Amount",100,45,37,95,82]
[null,"Delivery Date","2022-12-25","2022-12-18","2022-12-20","2022-12-24","2022-12-29"]