In Google Sheets, when you add a field to Columns, what happens?

• A. Creates header columns across the top.
• B. Groups data vertically.
• C. Changes the data source.
• D. Deletes duplicates.

Answer: (A)

When you place a field in Columns in a pivot table, Google Sheets uses the distinct values of that field to create separate column headers across the top of the pivot table. This arranges the data in a cross-tab format, with each unique value forming its own column and the table showing the corresponding measures in those columns. It doesn’t change the underlying data source, and it doesn’t group data vertically (that would be placing a field in Rows), nor does it delete duplicates. For example, putting a field like Region in Columns will yield a separate column for each region at the top of the pivot table.