本文介绍了如何在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), "♥")), "♦")))
更多推荐
如何在Google表格中自动将一行拆分为不同的行?
发布评论