英文:
Sorting and merging two columns in Google Sheets without whitespace: what's the solution?
问题
我想做的就是简单地将这两行不同信息的列（如鱼的类型）合并到右侧标有"both"的列中。我已经成功将它们合并，但存在所有的空白空间，而且我还需要按字母顺序排序。
我已经尝试过一些筛选函数，但我有点不知所措，只是一堆错误。
英文:
My sheet
What I want to do is simply combine these 2 rows of columns with different info like fish type and merge them into the column on the right where it says both, I managed to combine them but it has all the white spaces and I also need it to be sorted alphabetically.
I have tried fiddling with some filter functions but I am a bit clueless, just a bunch of errors
答案1
得分: 2
=尝试以下公式-
=SORT(UNIQUE(TOCOL(FLATTEN(A3:A,C3:C),1)))
英文:
Try the following formula-
=SORT(UNIQUE(TOCOL(FLATTEN(A3:A,C3:C),1)))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论