# Pivot Table
The **Pivot Table** task in **Gaio DataOS** allows you to reshape your dataset from a long format (rows) into a wide format (columns), turning categorical values into new columns. It’s ideal for creating cross-tab reports, category comparisons, and dashboard-ready summaries. {% hint style="warning" %} **Important:** This task can only be used when a **table is selected** in your flow. {% endhint %} *** ## How to Use ### **1. Open the Pivot Table Task** * In the left-side menu, go to:\ **Tasks > ETL > Pivot Table** *** ### **2. Set Task Name and Output Table** * **Task label**: (optional) A name for this task within your flow. * **Result table**: The name of the new table to be created from the pivot transformation. *** ### **3. Select Column to Pivot** * **Column to pivot**: Choose the column whose unique values will become new column headers (e.g., `product_category`). * **Sort values**: Choose the sorting order for the new columns: `Ascending` or `Descending`. *** ### **4. Configure Pivot Values** * A list of unique values from the pivot column will appear. * You can rename each one under the **Transpose** column to customize the new headers. *** ### **5. Select Value to Aggregate** * **Value to pivot**: Choose the numeric column you want to summarize (e.g., `sales_amount`, `units_sold`). * **Aggregation values**: Select the aggregation method: * `Sum` * `Average` * `Count`, etc. *** ### **6. Optional: Add Extra Columns** * **Extra columns**: Select columns that should be preserved in the output (e.g., `region`, `date`). * **Position of extra columns**: Choose whether they appear `At start` or `At end` of the resulting table. *** ### **7. Save and Run** * **Save**: Saves the task for later use in the flow. * Click **Run** to execute the task in your flow. *** Use Cases * Compare product categories side by side * Summarize metrics by region, time, or status * Create custom pivot views for dashboards * Transform transactional data into report-ready formats --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.gaiodataos.com/tools/tasks/etl/pivot-table.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.