将格内多行文字展开成多格
表格的A列是分类，B列由多行文字组成，即分隔符是换行符。
| A | B | |
| 1 | Account Number | Interaction |
| 2 | 1 | Jan 1,2023 - Hello. |
| 3 | 2 | Jan 2, 2023 - Good morning. Jan 3, 2023 - Good night. Jan 4, 20 Jan 5, 2023 - Good night. Jan 6, 2023 - Good afternoon. |
| 4 | 3 | Jan 1,2023 - Good night. Jan 2, 2023 - Good afternoon. |
请将B列的每格展开成多个单元格，并复制A列
| A | B | |
| 1 | Account Number | Interaction |
| 2 | 1 | Jan 1,2023 - Hello. |
| 3 | 2 | Jan 2, 2023 - Good morning. |
| 4 | 2 | Jan 3, 2023 - Good night. |
| 5 | 2 | Jan 4, 20 |
| 6 | 2 | Jan 5, 2023 - Good night. |
| 7 | 2 | Jan 6, 2023 - Good afternoon. |
| 8 | 3 | Jan 1,2023 - Good night. |
| 9 | 3 | Jan 2, 2023 - Good afternoon. |
使用 SPL XLL
=spl("=?.news@q(~2.import@si();[get(1)(1),~])",A2:B4)
函数 news@q 用序列的成员生成新序列，~2 是当前变量的第 2 个成员,import@si将字符串按回车解析成单行字符串组成的序列，get 在多层循环中按层数返回循环变量。
原文地址：https://blog.csdn.net/smilejingwei/article/details/140329098
免责声明：本站文章内容转载自网络资源，如本站内容侵犯了原著者的合法权益，可联系本站删除。更多内容请关注自学内容网（zxcms.com）！