如何在Google表格中自动将一行拆分为不同的行? [英] How to automatically split one row into different rows in Google Sheets?

问题描述

我正在尝试根据其内容将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), "♥")), "♦")))

这篇关于如何在Google表格中自动将一行拆分为不同的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！