The best replacement for pivot table is pivot chart.

The best alternatives to pivot table are rated as following:

★★★★★	pivot chart
★★★	table
★★★	powerpivot
★★	vlookup
★	crosstab
★	sumif
★	subtotal
★	crosstab query
	sumproduct
	olap cube
	olap
	filter excel
	excel pivot table

Your alternative for pivot table is not listed? Suggest!

Speaking about pivot table, one probably shouldn't forget about multiple ranges.

Other search terms related to pivot table and their ratings are:

★★★★★	multiple ranges
★★★★	count
★★★	summary
★★★	dynamic range
	macro

You have in mind a companion for pivot table and it is not yet here? Propose!

Google Trends

Scale is based on the average worldwide traffic of pivot table in all years. Click on graph for more.

pivot table

pivot chart

table