{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Mirror Text","Use of Combined Functions","Using CONCATENATE & TRANSPOSE","Applying VBA","Using User Defined Function","Using Format Shape Feature"],"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":"Mirror Text","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Mirror Text"]
[]
[null,"Name","Age ","Profession"]
[null,"Emily",17,"Student"]
[null,"Nick",36,"Teacher"]
[null,"Henry",45,"Doctor"]
[null,"Nancy",33,"Nurse"]
[null,"Rose",25,"Receptionist"]
[null,"Liam",35,"Driver"]
[null,"Daniel",50,"Doctor"]

{"sheet":"Use of Combined Functions","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of Combined Functions",null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Name","Mirror Text",null,null,null,null,null,null,"Name","Mirror Text"]
[null,"Emily",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B5,ABS(ROW(INDIRECT(\"1:\"&LEN(B5)))-(LEN(B5)+1)),1))","v":"ylimE"},null,null,null,null,null,null,"Emily"]
[null,"Nick",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B6,ABS(ROW(INDIRECT(\"1:\"&LEN(B6)))-(LEN(B6)+1)),1))","v":"kciN"},null,null,null,null,null,null,"Nick"]
[null,"Henry",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B7,ABS(ROW(INDIRECT(\"1:\"&LEN(B7)))-(LEN(B7)+1)),1))","v":"yrneH"},null,null,null,null,null,null,"Henry"]
[null,"Nancy",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B8,ABS(ROW(INDIRECT(\"1:\"&LEN(B8)))-(LEN(B8)+1)),1))","v":"ycnaN"},null,null,null,null,null,null,"Nancy"]
[null,"Rose",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B9,ABS(ROW(INDIRECT(\"1:\"&LEN(B9)))-(LEN(B9)+1)),1))","v":"esoR"},null,null,null,null,null,null,"Rose"]
[null,"Liam",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B10,ABS(ROW(INDIRECT(\"1:\"&LEN(B10)))-(LEN(B10)+1)),1))","v":"maiL"},null,null,null,null,null,null,"Liam"]
[null,"Daniel",{"$f":"_xlfn.TEXTJOIN(\"\",1,MID(B11,ABS(ROW(INDIRECT(\"1:\"&LEN(B11)))-(LEN(B11)+1)),1))","v":"leinaD"},null,null,null,null,null,null,"Daniel"]

{"sheet":"Using CONCATENATE & TRANSPOSE","index":2,"n_rows":12,"n_cols":16,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,14,1,19]]}
[]
[null,"Using CONCATENATE & TRANSPOSE Functions",null,null,null,null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Name","Emily",null,null,null,null,null,null,null,null,null,null,null,"Name","Emily"]
[null,null,{"$f":"MID($C$4,LEN($C$4)-ROW(C1)+1,1)","v":"y"}]
[null,null,{"$f":"MID($C$4,LEN($C$4)-ROW(C2)+1,1)","v":"l"}]
[null,null,"i"]
[null,null,"m"]
[null,null,"E"]
[]
[null,"Transpose",{"$f":"TRANSPOSE(C5:C9)","v":"y"},"l","i","m","E",null,null,null,null,null,null,null,"Transpose"]
[null,"Mirror Text",{"$f":"CONCATENATE(C11,D11,E11,F11,G11)","v":"ylimE"},null,null,null,null,null,null,null,null,null,null,null,"Mirror Text"]

{"sheet":"Applying VBA","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Applying VBA",null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Name","Mirror Text",null,null,null,null,null,null,"Name","Mirror Text"]
[null,"Emily","ylimE",null,null,null,null,null,null,"Emily"]
[null,"Nick","kciN",null,null,null,null,null,null,"Nick"]
[null,"Henry","yrneH",null,null,null,null,null,null,"Henry"]
[null,"Nancy","ycnaN",null,null,null,null,null,null,"Nancy"]
[null,"Rose","esoR",null,null,null,null,null,null,"Rose"]
[null,"Liam","maiL",null,null,null,null,null,null,"Liam"]
[null,"Daniel","leinaD",null,null,null,null,null,null,"Daniel"]

{"sheet":"Using User Defined Function","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using User Defined Function",null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Name","Mirror Text",null,null,null,null,null,null,"Name","Mirror Text"]
[null,"Emily",{"$f":"Mirror(B5)","v":"ylimE"},null,null,null,null,null,null,"Emily"]
[null,"Nick",{"$f":"Mirror(B6)","v":"kciN"},null,null,null,null,null,null,"Nick"]
[null,"Henry",{"$f":"Mirror(B7)","v":"yrneH"},null,null,null,null,null,null,"Henry"]
[null,"Nancy",{"$f":"Mirror(B8)","v":"ycnaN"},null,null,null,null,null,null,"Nancy"]
[null,"Rose",{"$f":"Mirror(B9)","v":"esoR"},null,null,null,null,null,null,"Rose"]
[null,"Liam",{"$f":"Mirror(B10)","v":"maiL"},null,null,null,null,null,null,"Liam"]
[null,"Daniel",{"$f":"Mirror(B11)","v":"leinaD"},null,null,null,null,null,null,"Daniel"]

{"sheet":"Using Format Shape Feature","index":5,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,13,1,15]]}
[]
[null,"Using Format Shape Feature",null,null,null,null,null,null,null,null,null,null,null,"Using Format Shape Feature"]
[]
[null,"Name","Age ","Profession",null,null,null,null,null,null,null,null,null,"Name","Age ","Profession"]
[null,"Emily",17,"Student",null,null,null,null,null,null,null,null,null,"Emily",17,"Student"]
[null,"Nick",36,"Teacher",null,null,null,null,null,null,null,null,null,"Nick",36,"Teacher"]
[null,"Henry",45,"Doctor",null,null,null,null,null,null,null,null,null,"Henry",45,"Doctor"]
[null,"Nancy",33,"Nurse",null,null,null,null,null,null,null,null,null,"Nancy",33,"Nurse"]
[null,"Rose",25,"Receptionist",null,null,null,null,null,null,null,null,null,"Rose",25,"Receptionist"]
[null,"Liam",35,"Driver",null,null,null,null,null,null,null,null,null,"Liam",35,"Driver"]
[null,"Daniel",50,"Doctor",null,null,null,null,null,null,null,null,null,"Daniel",50,"Doctor"]