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: