Changing an excel sheet from landscape (landscape data) to portrait (vertical data) mainly involves transposing the data. This means that you convert the data in a column into the data in a row, or vice versa. Excel provides several ways to do this, but here are two common ones:
Select and copy the dataFirst, select the area of data you want to transpose, then right-click and select "Copy", or use the shortcut keyctrl + c
Select the paste location: Select a new location in the worksheet to paste the data you just copied. Make sure that the new location you choose doesn't overwrite any of the data you want to keep.
Paste special operations: Right-click on the paste location of your choice, select the "Paste Special" option, and then select the "Transpose" option in the dialog box that pops up. You can also do this by clicking the "Paste" drop-down menu in the Start tab and selecting the "Transpose" icon.
Finish pasting: Click OK and your data will be transposed and pasted into the new location.
You can use it if you want to pivot the data dynamically (i.e., when the source data is updated, the transposed data is updated with it).transposeFunction.
Select the target region: Depending on the size of the data you want to transpose, select an area that is large enough to place the transposed data. For example, if your raw data is 5 rows and 10 columns, then you need to select a region of 10 rows and 5 columns to paste the data.
Enter the transpose function: Enter in the first cell of the region you selected=transpose(and select the data region you want to transpose as the function parameter. When you're done making your selections, enterClosing function.
Array formula input: In order to maketransposeThe function acts on the entire selected area, and you need to enter it as an array formula. This usually means that you need to press it after you have entered the functionctrl + shift + enterAnd not just pressenter。This way, Excel will apply the formula to the entire selected area, and you will see the formula curly bracketed in the formula barbracket, indicating that this is an array formula.
Please note that the usetransposeThe region of the function cannot overlap with the original data region and is used when the original data changestransposeThe function's method automatically updates the transposed data.