These two added headers should simply take all the data from the pivot table ( as it is already sorted and in order, so this would be easier than reading from the original file called Cado)推荐答案不确定文件"Company"是否是枢纽.但是,如果没有,那么,如果两个文件都包含员工编号,则可以简单地使用vlookup提取名称和小时数.Not sure if file 'Company' is a pivot or not. But, if not, then if both files contain the Employee No. you could simply use a vlookup to pull in the name and hours off of the pivot. 这篇关于从数据透视表中获取数据并插入特定的标题下的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!