下午好。
我正在尝试合并一个充满重复值的表，我发现"合并"功能对此非常有效，但是我偶然发现的问题是它不会保留"材料"文本与它合并后。
这是原始数据：
Part Number Quantity Material
02210144US 3 22ga Galvanized
02210144US 3 22ga Galvanized
02210144US 3 22ga Galvanized
02210144US 2 22ga Galvanized
02210144US 2 22ga Galvanized
02210144US 2 22ga Galvanized
02332256US 2 26ga Galvanized
02332256US 2 26ga Galvanized
21010601 1 18ga Galvaneal
21010601 1 18ga Galvaneal
21073101 1 26ga Galvanized
21073101 1 26ga Galvanized
21073102 1 26ga Galvanized
21073103 1 26ga Galvanized
21073103 1 26ga Galvanized
21073103 1 26ga Galvanized
21073111 1 26ga Galvanized
21073111 1 26ga Galvanized
21073112 1 26ga Galvanized
21073113 1 26ga Galvanized
21073113 1 26ga Galvanized
21073113 1 26ga Galvanized
21073201 1 26ga Galvanized
21073201 1 26ga Galvanized
21073202 1 26ga Galvanized
21073203 1 26ga Galvanized
21073203 1 26ga Galvanized
21073203 1 26ga Galvanized
21073301 2 26ga Galvanized
21073301 2 26ga Galvanized
21073302 2 26ga Galvanized
21073303 2 26ga Galvanized
21073303 2 26ga Galvanized
21073303 2 26ga Galvanized
21073501 2 26ga Galvanized
21073501 2 26ga Galvanized
21073502 2 26ga Galvanized
21073503 2 26ga Galvanized
21073503 2 26ga Galvanized
21073503 2 26ga Galvanized
21081101 1 26ga Galvalume (Alu-Zinc)
21081101 1 26ga Galvalume (Alu-Zinc)
21081102 1 26ga Galvalume (Alu-Zinc)
21081103 1 26ga Galvalume (Alu-Zinc)
21081103 1 26ga Galvalume (Alu-Zinc)
21081103 1 26ga Galvalume (Alu-Zinc)
21081201 1 26ga Galvanized
21081201 1 26ga Galvanized
21081202 1 26ga Galvanized
21081203 1 26ga Galvanized
21081203 1 26ga Galvanized
21081203 1 26ga Galvanized
21420061P 1 22ga Galvaneal
21420061P 1 22ga Galvaneal
21422092P 2 22ga Galvaneal
21422092P 2 22ga Galvaneal
22011035B 2 22ga Black Pre-Painted
22011035B 2 22ga Black Pre-Painted
22011036B 3 22ga Black Pre-Painted
22011036B 3 22ga Black Pre-Painted
22011036B 3 22ga Black Pre-Painted
22011036B 2 22ga Black Pre-Painted
22070874BL 1 22ga Black Pre-Painted
22070874BL 1 22ga Black Pre-Painted
22070875BL 1 22ga Black Pre-Painted
22070876BL 1 22ga Black Pre-Painted
22070876BL 1 22ga Black Pre-Painted
22070876BL 1 22ga Black Pre-Painted
22070887B 1 22ga Black Pre-Painted
22070887B 2 22ga Black Pre-Painted
22070887B 1 22ga Black Pre-Painted
22070887B 2 22ga Black Pre-Painted
22070887B 2 22ga Black Pre-Painted
22273301 2 26ga Galvanized
22273301 2 26ga Galvanized
22273302 2 26ga Galvanized
22273303 2 26ga Galvanized
22273303 2 26ga Galvanized
22273303 2 26ga Galvanized
这就是我合并之后的样子：
(blank) Quantity Material
02210144US 15 (blank)
02332256US 4 (blank)
21010601 2 (blank)
21073101 2 (blank)
21073102 1 (blank)
21073103 3 (blank)
21073111 2 (blank)
21073112 1 (blank)
21073113 3 (blank)
21073201 2 (blank)
21073202 1 (blank)
21073203 3 (blank)
21073301 4 (blank)
21073302 2 (blank)
21073303 6 (blank)
21073501 4 (blank)
21073502 2 (blank)
21073503 6 (blank)
21081101 2 (blank)
21081102 1 (blank)
21081103 3 (blank)
21081201 2 (blank)
21081202 1 (blank)
21081203 3 (blank)
21420061P 2 (blank)
21422092P 4 (blank)
22011035B 4 (blank)
22011036B 11 (blank)
22070874BL 2 (blank)
22070875BL 1 (blank)
22070876BL 3 (blank)
22070887B 8 (blank)
22273301 4 (blank)
22273302 2 (blank)
22273303 6 (blank)
这就是我希望它的结果：
Part Number Quantity Material
02210144US 15 22ga Galvanized
02332256US 4 26ga Galvanized
21010601 2 18ga Neal
21073101 2 26ga Galvanized
21073102 1 26ga Galvanized
21073103 3 26ga Galvanized
21073111 2 26ga Galvanized
21073112 1 26ga Galvanized
21073113 3 26ga Galvanized
21073201 2 26ga Galvanized
21073202 1 26ga Galvanized
21073203 3 26ga Galvanized
21073301 4 26ga Galvanized
21073302 2 26ga Galvanized
21073303 6 26ga Galvanized
21073501 4 26ga Galvanized
21073502 2 26ga Galvanized
21073503 6 26ga Galvanized
21081101 2 22ga Galvanized
21081102 1 22ga Galvanized
21081103 3 22ga Galvanized
21081201 2 26ga Galvanized
21081202 1 26ga Galvanized
21081203 3 26ga Galvanized
21420061P 2 22ga Galvaneal
21422092P 4 22ga Galvaneal
22011035B 4 22ga Black Pre-Painted
22011036B 11 22ga Black Pre-Painted
22070874BL 2 22ga Black Pre-Painted
22070875BL 1 22ga Black Pre-Painted
22070876BL 3 22ga Black Pre-Painted
22070887B 8 22ga Black Pre-Painted
22273301 4 26ga Galvanized
22273302 2 26ga Galvanized
22273303 6 26ga Galvanized
知道我做错了什么？我已经检查了"左列"one_answers"顶行"的复选框，以及尝试的两个组合，只有一个，无等。谢谢您提供的任何帮助！
尝试：
- 选择所有数据
- 单击枢纽
- 将"零件号"拖到弹出的右窗格上的"行"框。
- 在"零件号"下方的"材料"中的"材料"。
- 将"数量"拖动到"值"框
接下来，我们更正格式：
- 单击顶部的"设计"选项卡
- 单击"小计"，'请勿显示小计'
- 单击"总计"，"排成行和列"
- 单击"报告布局"，'重复所有项目标签'
- 单击"报告布局"，'以表格形式显示
这应该做到这一点，但是它切换了材料和数量列。
- 现在您有了数据，如果您希望它从枢纽表格中取出，可以选择所有数据，复制，右键单击另一张纸，单击其上面有123的粘贴图标(粘贴值(。