{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["setting","main","matrix","table"],"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":"setting","index":0,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["設定"]
["■ マトリックス表の設定"]
["列",null,"行"]
["start","end","start","end"]
[{"$f":"IFERROR(MATCH(\"*?\",INDEX(matrix!A:A&\"\",0),0),0)","v":2},{"$f":"IFERROR(COUNTA(matrix!A:A)+1,0)","v":9},{"$f":"IFERROR(MATCH(\"*?\",INDEX(matrix!1:1&\"\",0),0),0)","v":2},{"$f":"IFERROR(COUNTA(matrix!1:1)+1,0)","v":4}]

{"sheet":"main","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["マトリックス形式から表形式のデータに変換するマクロ"]
[]
[]
[]
[]
[]
[null,"■","概要"]
[]
[null,null,"これはマトリックス形式を表形式のデータに変換するマクロです。"]
[]
[null,null,null,"マトリックス形式",null,null,null,null,null,"表形式"]
[null,null,null,null,"a","b",null,null,null,"A","a",1]
[null,null,null,"A",1,2,null,"→",null,"A","b",2]
[null,null,null,"B",4,5,null,null,null,"B","a",3]
[null,null,null,null,null,null,null,null,null,"B","b",4]
[]
[null,"■","使い方"]
[]
[null,null,"①","「matrix」シートにマトリックス形式のデータを登録します。"]
[null,null,"②","「main」シートの【実行】ボタンを押下します。"]
[null,null,"③","「table」シートに表形式のデータが作成されます。"]
[]
[]
[null,"■","注意点"]
[]
[null,null,"①","「matrix」シートの列名と行名（色がついているセル）の値が入っている箇所がデータとして「table」シートに出力されます。"]

{"sheet":"matrix","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"a",{"$f":"CHAR(CODE(B1)+1)","v":"b"},{"$f":"CHAR(CODE(C1)+1)","v":"c"}]
["A",1,2,3]
[{"$f":"CHAR(CODE(A2)+1)","v":"B"},4,5,6]
[{"$f":"CHAR(CODE(A3)+1)","v":"C"},7,8,9]
["D",10,11,12]
["E",13,14,15]
["F",16,17,18]
["G",19,20,21]
["H",22,23,24]

{"sheet":"table","index":3,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["A","a",1]
["A","b",2]
["A","c",3]
["B","a",4]
["B","b",5]
["B","c",6]
["C","a",7]
["C","b",8]
["C","c",9]
["D","a",10]
["D","b",11]
["D","c",12]
["E","a",13]
["E","b",14]
["E","c",15]
["F","a",16]
["F","b",17]
["F","c",18]
["G","a",19]
["G","b",20]
["G","c",21]
["H","a",22]
["H","b",23]
["H","c",24]