Transforming Data

To transform data:

1	Select one or more columns of data (by clicking on the column label).

2	Choose Data > Data Transformations to display the Data Transformations dialog box.

3	Choose the desired transform from the Data Transformations drop-down list.

If you choose Constant Value as the transform, enter a value.

4	Click OK to transform the data.

Click Apply instead of OK to repeat the process and transform more data or further transform the data.