Then click on the location where the data needs to be converted and right-click on that cell -> select Paste Special.
When the Paste Specia l dialog box appears, check the box before Transpose
Finally click OK to complete. And here is the result of converting columns to rows in Excel.
With the above not too difficult operations, you can simplify converting columns into rows on Excel spreadsheets, thereby saving you a lot of time and effort compared to manually having to re-enter data if you accidentally make a mistake. wrong.
A trick in Excel that is also followed by many people is how to serialize data in Excel columns. Numbering in columns helps you save time with data tables of up to thousands of rows, if If you don't know clearly, please refer to Taimienphi.