convert multiple columns to rows in excel

Let’s see how this can be achieved in both the above cases. The new versions of Excel provide a special feature that lets you do that using the ‘Data’ menu. The best way to work through the above two problems is by splitting one column into multiple columns. In other cases, you might have got a list of addresses, but want to organize this data properly so you can clearly see how many of the people reside in, say, New York. If the volume of the data is very large then it’s usually quite difficult to structure the data’s readability.įor example, you might have got data with a list of names, and you might want to arrange the names in alphabetical order of surnames. However, sometimes you need to work with data that someone else has created. When entering data from scratch, it’s possible to ensure that we structure the data to be more readable. One of the best ways to make your data more readable is to split it into chunks so that it is easier to access the right information. It makes the data easier to skim through and work with. When working with data and spreadsheets, readability, and structure matter a lot.

Convert multiple columns to rows in excel