|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 liyongjjjjjj 于 2013-1-19 15:16 编辑
我们做完数据透视表后,有好多空白的地方,我想让它自动填充,以方便后期处理。见附件。谢谢!
班别1 | 挡车工 | 品种辅助列 | 汇总 | 甲 | 成安群 | 白80S | 763 | |
| 花20S
| 906.78 | |
| 花26S
| 151.11 | |
| 花30S
| 35.44 | |
| 花40S
| 129.62 | |
| 花50S
| 28.48 | |
| 花54S
| 355.1 | |
| 花60S
| 75.22 | |
| 花70S
| 5.74 | |
| 花76S
|
|
|
| 花80S
| 17.51 | | 成安群、丁宏翠 | 花20S | 821 | |
| 花30S
| 30 | |
| 花50S
| 60 | | 成安群、潘秀萍 | 花20S | 509 | |
| 花30S
| 84 | | 成安群、王尚英 | 花20S | 395 | |
| 花30S
| 31 | ,我想要的效果如下:
班别1 | 挡车工 | 品种辅助列 | 汇总 | 甲 | 成安群 | 白80S | 763 | 甲 | 成安群 | 花20S | 906.78 | 甲 | 成安群 | 花26S | 151.11 | 甲 | 成安群 | 花30S | 35.44 | 甲 | 成安群 | 花40S | 129.62 | 甲 | 成安群 | 花50S | 28.48 | 甲 | 成安群 | 花54S | 355.1 | 甲 | 成安群 | 花60S | 75.22 | 甲 | 成安群 | 花70S | 5.74 | 甲 | 成安群 | 花76S |
| 甲
| 成安群 | 花80S | 17.51 | 甲 | 成安群、丁宏翠 | 花20S | 821 | 甲 | 成安群、丁宏翠 | 花30S | 30 | 甲 | 成安群、丁宏翠 | 花50S | 60 | 甲 | 成安群、潘秀萍 | 花20S | 509 | 甲 | 成安群、潘秀萍 | 花30S | 84 | 甲 | 成安群、王尚英 | 花20S | 395 | 甲 | 成安群、王尚英 | 花30S | 31 |
|
|