Using row transformations
In addition to the row transformations mentioned in the Sorting and filtering section, there are row transformations that can be helpful under the Transform tab of the ribbon:
- Replace Values – This provides a user interface where you define the value being searched for and the value you want to replace. It works the same as Find and Replace works on most text editors, such as Notepad.
- Replace Errors – This is similar to Replace Values where it provides an option for the replacement of rows that contain error values. The definition of an error will depend on the data type.
- Reverse Rows – This is a way of sorting the rows such that the data is shown or stored in reverse order. The first row becomes the last, the last row becomes the first, and all order in between is preserved.
- Transpose – Transpose functions as both a row and a column transformation as it turns each row into its own column and each column into...