How to change the horizontal data copied in excel to vertical when pasting

When we are working on excel table data processing, we often encounter the problem of copying horizontal data to another location, but asking for vertical placement for processing. This experience will help you answer how to switch quickly. problem. 1. Open the excel table to be processed. 2. We simply use the summation formula to calculate the data. 3. Select the data to be copied (ctrl+c) (in the state of the virtual box) 4. Paste the selected data into the file selectively. In other places, the data is still horizontal. 5. In order to change the status quo, we right click and select the Paste button to enter the dialog box. 6. Select the Transpose button in the dialog box and click OK. The pasted content becomes vertical data, and you're done