如果表位于A1:E7范围内，请尝试以下公式

If the table you is in range A1:E7, try this formula

=TRANSPOSE(SPLIT(REGEXREPLACE(REGEXREPLACE(REGEXREPLACE(ARRAYFORMULA(CONCATENATE($B$2:$B$7&"|")),$C$2,$D$2),$C$3,$D$3),$C$4,$D$4),"|"))

您可以在较早的帖子中进一步了解 ，并且 Google文档论坛.

You can read further about this in an older post and google docs forum.