LABEL for column headers in Google Sheets - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a clear sales summary table with labeled column headers for easy reading.

📊 Data: You have raw sales data with product names, units sold, and total revenue but no clear headers.

🎯 Deliverable: Create a summary table with proper column headers using QUERY's LABEL clause to make the data easy to understand.

Sample Data

Apple	50	200
Banana	30	90
Cherry	20	120
Date	40	160
Elderberry	10	50

1

Step 1: Select a new area in the sheet to create the summary table with headers.

Leave blank (manual selection).

Expected Result

Empty area ready for the summary table.

2

Step 2: Use the QUERY function with the LABEL clause to add headers 'Product', 'Units Sold', and 'Revenue' above the data.

=QUERY(A1:C5, "SELECT * LABEL Col1 'Product', Col2 'Units Sold', Col3 'Revenue'")

Expected Result

A table with headers 'Product', 'Units Sold', and 'Revenue' above the data rows.

3

Step 3: Verify the headers appear correctly and the data aligns under each header.

No formula needed; visually check alignment.

Expected Result

Headers are visible and data is correctly placed under each header.

Final Result

Product     Units Sold     Revenue
Apple       50             200
Banana      30             90
Cherry      20             120
Date        40             160
Elderberry  10             50

✓The summary table now clearly shows product names with their units sold and revenue.

✓Using QUERY's LABEL clause helps add meaningful headers without manually typing them above the data.

Bonus Challenge

Create a dynamic summary table that updates headers automatically when data changes.

Show Hint

Use ARRAYFORMULA or QUERY with LABEL to keep headers and data linked.