With a simple table of data (columns and rows) a pivot table provides grouping/sorting/filtering, and basic data aggregation functions.

The result is a interactive click/draggable table, where items can be moved around, hierarchies of aggregation changed, rows/columns transposed, and the like. I think that's where the word "pivot" comes from.