Changing the Data Layout

You can easily change how the data is laid out in the data grid. The choices are:

Maintain current data layout Keep the data as it is currently laid out.
Distribute data across the first row, then across the second row, and so on Fill the first row, then the second row, and so on. You specify how many columns to fill across the rows before starting a new row.
Distribute data down the first column only Start a new row for each new data field. Fills the first column only.

To change the data layout

  1. Enter or import data into the data grid.
  2. Click in the top left corner of the data grid.

    The Change Data Layout dialog box appears.

  3. Select how you want the data to appear in the data grid.
  4. View the data in the Preview area.
  5. When satisfied with the data layout, click Change.

See Also

 

Was this topic helpful? Send us your feedback