{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Using Transpose Function","Using the Ampersand Sign","Using TEXTJOIN","Using CONCATENATE Function","Implementing Power Query","Pivot Table Result","Using VBA Code"],"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":"Using Transpose Function","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9],[4,4,4,9]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name",null,"Student ID"]
[null,1612030,"Maria",null,{"$f":"TRANSPOSE(B6:B11)","v":1612030},1612031,1612032,1612033,1612034,1612035]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer"]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]

{"sheet":"Using the Ampersand Sign","index":1,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,4,4,9],[2,1,2,9]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name",null,"Student ID"]
[null,1612030,"Maria",null,1612030,1612031,1612032,1612033,1612034,1612035]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6&\" \"&B7&\" \"&B8&\" \"&B9&\" \"&B10&\" \"&B11&\" \"","v":"1612030 1612031 1612032 1612033 1612034 1612035 "}]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]

{"sheet":"Using TEXTJOIN","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,4,4,9],[2,1,2,9]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name",null,"Student ID"]
[null,1612030,"Maria",null,1612030,1612031,1612032,1612033,1612034,1612035]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer"]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]

{"sheet":"Using CONCATENATE Function","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,4,4,9],[2,1,2,9]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name",null,"Student ID"]
[null,1612030,"Maria",null,1612030,1612031,1612032,1612033,1612034,1612035]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer"]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]

{"sheet":"Implementing Power Query","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name"]
[null,1612030,"Maria"]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer"]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]

{"sheet":"Pivot Table Result","index":5,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Column1","Column2","Column3","Column4","Column5","Column6"]
[1612030,1612031,1612032,1612033,1612034,1612035]
["Maria","Sheldon","Maradona","Jenifer","Ronaldo","Thiago"]

{"sheet":"Using VBA Code","index":6,"n_rows":28,"n_cols":33,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting Multiple Rows to Single Row"]
[]
[null,"Student ID","Student Name"]
[null,1612030,"Maria",null,1612030,1612031,1612032,1612033,1612034,1612035]
[null,1612031,"Sheldon"]
[null,1612032,"Maradona"]
[null,1612033,"Jenifer"]
[null,1612034,"Ronaldo"]
[null,1612035,"Thiago"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1612030,1612031,1612032,1612033,1612034,1612035]