> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data.md).
# Explore and organize data
PowerTable provides several options to help you search, organize, and analyze data in a table. You can search for records, sort and reorder columns, show or hide columns, pin columns for easier navigation, and view column insights to better understand your data.
In this article, you learn how to:
* [Search](#search-records) for records in a table.
* [Sort](#sort-records) records
* [Reorder](#reorder-columns) columns.
* [Show or hide](#show-or-hide-columns) columns.
* [Pin and unpin](#pin-columns) columns.
* View column [insights](#view-column-insights).
### Search records
Use the **Search** box to quickly locate records by entering text, numbers, or phrases.
To search for records:
1. Select the **Search** box on the toolbar.
2. Enter the text, number, or phrase that you want to find.
PowerTable sheet filters the table and displays matching records as you type. Search results are returned across all pages of the table.
### Sort records
PowerTable provides standard sorting options to organize records in ascending or descending order based on the values in a selected column. You can sort numeric and non-numeric columns, including numbers, text, dates, and single-select fields.
To sort records:
1. Hover over the required column header and select the three-dot menu.
2. Select **Sort Ascending** or **Sort Descending**.
The following example shows the *ProductSKU* column sorted in ascending order.
To remove sorting, select **Remove Sort** from the same menu.
### Reorder columns
You can reorder columns to customize the table layout.
To change the position of a column, drag the column header and drop it in the required location.
The following example shows the *ProductSKU* column reordered next to the *ProductName* column.
### Show or hide columns
You can hide columns that are not required for your view and display them again when needed.
To hide a column:
1. Hover over the required column header.
2. Select the three-dot menu and then select **Hide**.
The *ProductDescription* column is hidden from the table view.
To display all hidden columns, select **Show All Columns** from the menu on any column header.
### Pin columns
Pinning keeps important columns visible on the left while you scroll horizontally through the table.
To pin a column:
1. Hover over the required column header.
2. Select the three-dot menu, and then select **Pin**.
The pinned *ProductName* column moves to the left side of the table and remains visible during horizontal scrolling.
You can pin multiple columns if required.
To remove a pinned column, select **Unpin** from the same menu. To remove all pinned columns, select **Unpin All**.
### View column insights
Use **Insights** to view summary statistics and key information about a column. Column insights help you quickly understand data distribution, completeness, and trends without creating additional calculations.
To view column insights:
1. Hover over the required column header.
2. Select the three-dot menu, and then select **Insights**.
Depending on the column data type, the following insights are available:
* Sum
* Average
* Median
* Minimum value
* Maximum value
* Range
* Standard deviation
* Number and percentage of empty values
* Number and percentage of populated values
* Number and percentage of unique values
* Earliest date
* Latest date
* Date range
Use these insights to identify patterns, validate data quality, and make informed decisions. The following example shows column insights for a few columns.
To view all available insights for the selected column, select **Show All** in the Insights dropdown.
You can also access the **Sort**, **Hide**, **Pin**, and **Insights** options from the toolbar after selecting a column.
### View column profile
The **Column Profile** option provides a quick summary of the data in each column. It displays the number of **Filled**, **Empty**, **Unique**, and **Distinct** values, so you can assess data completeness and identify potential data quality issues.
To view the column profile:
1. Select **Format** > **Column Profile** on the toolbar.
2. PowerTable displays a profile row below the column headers. The profile includes:
* **Filled** and **Empty** values, shown in both count and percentage.
* **Unique** and **Distinct** values, shown as counts.
3. To hide the column profile and return to the default view, select **Column Profile** again.
### Clean up data
The **Data Cleanup** option improves data quality by removing duplicate and empty values from a selected column.
To clean up data:
1. Hover over the required column header, and then select the **three-dot** menu.
2. Select **Data Cleanup**.
3. Select one of the following options:
* **Remove Duplicates** - Removes duplicate values from the selected column.
* **Remove Empty** - Removes rows that contain empty values in the selected column.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## 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, and the optional `goal` query parameter:
```
GET https://docs.fabricplan.com/documentation/plan/powertable-sheets/how-tos/explore-and-organize-data.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.
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.