Combine two identical excel files into one PowerPivot table
I came across a great blog post that shows how to import two excel sheets that have a similar column structure into one PowerPivot Table:
http://blog.contextures.com/archives/2010/09/06/powerpivot-from-identical-excel-files/
Very nice!
This is a wonderful/useful post. Thanks for sharing.