Complex sentence: Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet and create a second table (called a "pivot table") displaying the summarized data.
Split into simpler sentences: Among other functions, pivot-table tools can automatically sort, count, total or give the average of the data stored in one table or spreadsheet. It displays the results in a second table (called a "pivot table") showing the summarized data.