arrays - 有没有办法导入html表并跳过重复的列标题？

Question

我正在尝试从表格格式的 ESPN 导入数据，但表格在整个表格中重复标题，如果可能，我想跳过它们。

http://www.espn.com/nhl/statistics/team/_/stat/scoring/year/2019/seasontype/2

我希望它只在最顶部导入这一行一次，而不是重复！这可能吗？

RK  TEAM    GP  G   GA  GF/G    GA/G    DIFF    SF/G    SA/G    DIFF    SVPCT   PIM PIMA    DIFF

标签： arraysgoogle-sheetsimportuniquegoogle-sheets-formula

Answer 1

尝试：

=UNIQUE(IMPORTHTML("http://www.espn.com/nhl/statistics/team/_/stat/scoring/year/2019/seasontype/2", 
 "table", 1))