Google Sheets automatically enters the number of columns you have selected in the drop-down menu. Using our example, we pick Insert 3 columns right. Image used with permission by copyright holder ...

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.