作者:贵族灬阿宝 | 来源:互联网 | 2023-05-19 08:18
PerhapsImtryingtodotoomuch,butIhaveacolumnfilledwithtext.Eachcellhasanarbitrary
Perhaps I'm trying to do too much, but I have a column filled with text. Each cell has an arbitrary number of words, so for example:
也许我想做太多,但我有一个充满文字的专栏。每个单元格都有任意数量的单词,例如:
| A |
=====|====================|
1 | apple pear yes cat |
2 | apple cat dog |
3 | pear orange |
What I need to do is create a column which is a list of all unique words in that range. So for the above example, the result should be:
我需要做的是创建一个列,该列是该范围内所有唯一单词的列表。所以对于上面的例子,结果应该是:
| A | B |
=====|====================|========|
1 | apple pear yes cat | apple |
2 | apple cat dog | pear |
3 | pear orange | yes |
4 | | cat |
5 | | dog |
6 | | orange |
In no particular order. Is there any way to do this?
没有特别的顺序。有没有办法做到这一点?
2 个解决方案