When you copy values from a poorly formatted data source into an Excel spreadsheet, the results may be quite useless. Instead of distributing everything neatly in rows and columns, data is, for example, continuously inserted below the last entry – with all entries in only one column. It can take a long time to subsequently sort this by hand. However, Excel also allows you to transpose data and split it into columns.
First copy a data set – i.e. all values that belong together – into the clipboard. In the Excel document, then right-click on a cell of your choice and select “Transpose”. Now the cell contents are not sorted under each other, but alongside each other. This step is repeated for all data sets and can therefore bring all the data into the desired order. This saves a fair bit of work. However, if you need to bring larger amounts of data into a new order, it is better to use formulas for this purpose.