K krishkumaraca New Member Joined Jan 22, 2014 Messages 1 Jan 22, 2014 #1 Hi everone, I am having data in table format in different files. But header is same for all the files. Now i want to merge all the files in Pivot table format for analysis. How we can merge in Excel 2007? please help me.