data
- A1
=IMPORTDATA("https://www.tele.soumu.go.jp/musen/list?ST=1&DA=1&SC=1&DC=2&OF=1&OW=FB&IT=E&HCV=29000&NA=%8Ay%93V%83%82%83o%83C%83%8B")
filter
- A1
=QUERY(data!A:Z,"SELECT A,C,X LABEL A '', C '' , X ''", TRUE)
- D1
=QUERY(ARRAYFORMULA(SPLIT(C:C,"\n",FALSE)), "WHERE Col1<>'#VALUE!'")
stack
- A1
=QUERY(ARRAYFORMULA(SPLIT(FLATTEN(filter!A:A&""&filter!B:B&""&filter!D:H),"_")),"WHERE Col3<>''")
- D1
=QUERY(ARRAYFORMULA(SPLIT(C:C,"\t",FALSE)), "WHERE Col1<>'#VALUE!'")
result
=QUERY(stack!A:F,"SELECT A,B,D,E,F LABEL A '番号', B '市区町村' , D '型式', E '周波数', F '空中線電力'", FALSE)
