如何在Google表格中自动将一行拆分为不同的行?

本文介绍了如何在Google表格中自动将一行拆分为不同的行?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试根据其内容将Google表格中的一行拆分为不同的行.这是一个示例:

I'm trying to split one row in Google Sheets into different rows depending on its content. Here's an example:

Name | Ticker | Categories Bitcoin | BTC | currency; store-of-value; trust layer; smart contracts; cross-industry Ripple | XRP | currency; cross-industry

进入:

Name | Ticker | Categories Bitcoin | BTC | currency Bitcoin | BTC | store-of-value Bitcoin | BTC | trust layer Bitcoin | BTC | smart contracts Bitcoin | BTC | cross industry Ripple | XRP | currency Ripple | XRP | cross-industry

如何使用脚本或任何其他工具来做到这一点?

How can I do this using a script or any other tools?

推荐答案

=ARRAYFORMULA(TRIM(SPLIT(TRANSPOSE(SPLIT(QUERY(TRANSPOSE(QUERY(TRANSPOSE( IF(IFERROR(SPLIT(C1:C, ";"))<>"", "♥"&A1:A&"♦"&B1:B&"♦"& IFERROR(SPLIT(C1:C, ";")), )),,999^99)),,999^99), "♥")), "♦")))