Home
Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
Results pane
The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.
Single-row view
View the cells in a single row of data, arranged vertically.
View data one row at a time
You can change your view to just a single row to see all of the information pertaining to that row, which is particularly useful when a table has many columns.

Trillion-Row Spreadsheet
The Trillion-Row Spreadsheet (TRS) allows you to visually interact with your data.
- Analyze
  The Analyze tab displays the object browser and the Analysis Timeline.
- Query
  The Query tab displays the current timeline query as Macro Language XML code. It also provides the ability to undo and redo operations in the timeline.
- View
  Select among the ways to view and interact with the data resulting from your analysis.
- Visualize
  The 1010data Insights Platform provides a mechanism to generate high-quality charts, which in turn can support the notion of visual data discovery.
- Develop
  Use the query that represents your analysis as a base for further development.
- Export
  Export the data resulting from your analysis to various destinations.
- Results pane
  The results pane is displayed on the right side of the Trillion-Row Spreadsheet window and Macro Language Workshop.
  - View bar
    Choose how data is displayed in the results pane of the Trillion-Row Spreadsheet and Macro Language Workshop.
  - Grid view
    The Grid view displays data in an infinitely-scrollable, spreadsheet-like interface in the results pane of the Trillion-Row Spreadsheet.
  - Single-row view
    View the cells in a single row of data, arranged vertically.
    - View data one row at a time
      You can change your view to just a single row to see all of the information pertaining to that row, which is particularly useful when a table has many columns.
  - Data Dictionary
    Displays the metadata of columns and tables in the analysis.
  - Visualization
    Displays the chart created from the data analysis.
  - Display a view from the view history
    Display a different view from the view history.
  - Clone the TRS window
    Clone the current view in the Trillion-Row Spreadsheet to a new TRS window.

View data one row at a time

You can change your view to just a single row to see all of the information pertaining to that row, which is particularly useful when a table has many columns.

To view data one row at time:

Do one of the following:
- In the results pane of the Trillion-Row Spreadsheet, click the Single-row view () icon.
- In the grid of the results pane, right-click any entry and select View this row in single-row mode.
A list of all the columns and their values for the current row is displayed. The current row number is also shown above the list.

To view different rows, click one of the following icons:

Choice	Result
Previous row ()	Displays the previous row of the table in the Single-row view.
Next row ()	Displays the next row of the table in the Single-row view.

You can perform a search within Single-row view, just as you can in Grid view. See Finding rows in the results pane for more information.