因此,我一直在寻找所需的信息,尽管似乎应该有一个简单的解决方案,但实际上还没有找到一个简单的解决方案.基本上,我有以下
So I've been searching for the information I need and have not really been able to find a simple solution, though it seems like there should be one. Basically, I have the following
约翰|母鹿| 123小袋鼠| 00123 | | |
John | Doe | 123 Wallaby Ln | 00123 | | |
约翰|母鹿| | 00123 | xxx | yy |
John | Doe | | 00123 | xxx | yy |
简|母鹿| | 01234 | | zz |
Jane | Doe | | 01234 | | zz |
简|母鹿| blep blop ln | | xx | |
Jane | Doe | bleep blop ln | | xx | |
我需要
约翰|母鹿| 123小袋鼠| 00123 | xxx | yy |
John | Doe | 123 Wallaby Ln | 00123 | xxx| yy |
简|母鹿| blep blop ln | 01234 | xx | zz |
Jane | Doe | bleep blop ln | 01234 | xx | zz |
基本上很简单,我需要合并具有相同第1列和第2列的单元格第2列的数据以获得尽可能完整和简洁的数据列表.您可能会认为这很容易通过Google作为一个简单的公式获得,但我只发现了VBA解决方案(我以前从未使用过VBA,也没有使用过宏,因此我不确定如何使用它们或修复其中的错误).任何帮助是极大的赞赏.
Basically pretty simple, I need to merge cells with the same Column 1 & Column 2 data to get as comprehensive and concise a list of data. You'd think this would be readily available through google as a simple formula but I have only found VBA solutions (I have never used VBA before, or macros for that matter so I'm not sure how to use them or fix errors in them). Any help is greatly appreciated.
提前谢谢!
推荐答案最简单的选择是合并A& B放在一列中(在C中插入新列)
The easiest option is to merge the content of A & B in one column ( insert a new column in C)
C1 =A1&" "&B1向下滚动公式
每列C的排序
确保在第1行上具有描述性名称来描述您的列.
Make sure you have descriptive name on row 1 to describe your column.
选择完整的表格
创建数据透视表,将C列放在行部分中以获得唯一名称列表.
Create a pivot table, drop the C column in the row section to obtain the list of unique name.
在新工作表中复制唯一名称列表
Copy the list of unique names in a new sheet
然后查看vlookupall,在此处进行描述具有多个结果的Excel vlookup 创建您的自己的功能.
and then look at vlookupall describe here excel vlookup with multiple results to create your own function.
更多推荐
excel根据列值合并行
发布评论