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.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...