How To Transpose Spreadsheets Data From Multiple Rows To Columns

  • WPS Office

In WPS Spreadsheets when you work with data listed in rows, you may want to transpose the data into columns. In this case, you will need to use the paste options in Spreadsheets. Take the following steps:

Step 1. Open the worksheet with the data you want to transpose, and select the data you want to rearrange. You need to select all the row or column labels, and press Ctrl+C.
transpose copy rows and cloumn

Step 2. Place cursor in a new cell where you want the rearranged data to be pasted, and then right click the mouse, and choose Paste Special menu. Or you can go to Home > Paste, click the drop-down-arrow beside paste option and choose the Paste Special Menu.
transpose copy rows and cloumn

Step 3. Choose Transpose from the pop up windows and click OK.

Step 4. Then you will find the rearranged columns and rows. After you have successfully pasted the transposed data, you can delete the original data.
transpose copy rows and cloumn

Notes: Please make sure you use the Copy command. If you tried the Cut command, the transpose option will not be available. If you have a lot of data to transpose, it might be faster to use TRANSPOSE function. It works when you only need to transpose one single row of data into a column, or vice versa.