Switch (transpose) columns and rows
If data is entered in columns or rows, but you want to rearrange that data into rows or columns instead, you can quickly transpose the data from one to the other. For example, the regional sales data that is organized in columns appears in rows after transposing the data, as shown in the following graphics.…