Switch rows and columns

Sometimes the data you import is organized vertically in columns, but you would like horizontal arrangement in rows. In these situations you can quickly switch the orientation of rows and columns. This operation is known as "Transpose" in traditional spreadsheet software.

To switch the orientation of rows and columns, simply click the Switch rows/columns button in the top left corner of the data grid:

Did you find what you were looking for? Thank you! There was a problem submitting your feedback. Please try again later.