将 Google Sheets 查询结果从一行拆分为两行

我想带着我的QUERY结果并将一个单元格（H [描述]）移动到每个结果的下一行。

I found 这个答案 https://stackoverflow.com/questions/56420002/how-to-automatically-split-one-row-into-different-rows-in-google-sheets，非常接近，但是表格的格式不同，所以我不确定如何将其应用到我的场景中。

这是基本思想：

    Category | Sub-Category | Item       | Description
    Fruit    | Citrus       | Orange     | It's orange
    Fruit    | Melon        | Cantaloupe | Round

Into

    Category | Sub-Category | Item  
    Fruit    | Citrus       | Orange     
    It's orange
    Fruit    | Melon        | Cantaloupe 
    Round

=ARRAYFORMULA(QUERY(SUBSTITUTE(TRIM(SPLIT(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(
 QUERY(TRANSPOSE(IF(IFERROR(SPLIT(C1:C, ";"))<>"", "♥"&A1:A&"♦"&B1:B&"♦"&
 IFERROR(SPLIT(C1:C, ";"))&"♥"&D1:D, )),,999^99)),,999^99), "♥")), "♦")), D1, ), 
 "where Col1 is not null", 0))

=ARRAYFORMULA(QUERY(SUBSTITUTE(TRIM(SPLIT(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(
 QUERY(TRANSPOSE(IF(C1:C<>"", "♥"&A1:A&"♦"&B1:B&"♦"&C1:C&"♥ ♦"&D1:D, ))
 ,,999^99)),,999^99), "♥")), "♦")), D1, ), 
 "where Col2 is not Null", 0))