You can also use Microsoft Query (which is built into Excel) to create a PivotTable without that Multiple Consolidation method. Or you can use a macro to do the same. Check out http://www.contextures.com/xlPivot08.html
And if you've got Excel 2010 - or Excel 2013 Professional - then you can use something called PowerPivot. Give google a spin for more info.
If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).
If the data is formatted text such as a CSV file, probably best to pull the data in with a query and work with the consolidated data using SQL statements (or use a database).
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.