Now, you can apply filters and see the data differently. Below is the final look of the converted datasheet. Now, select the option “Transpose.”ĭoing this will flip the column to rows and make the orientation as we needed. See the image below.Ī Paste dialogue box will open up.

Hit the Paste option given under the Clipboard menu.

Now, click on any blank cell from where you need the data to be.Or else you may press CTRL + C for copying the data.

Under the Clipboard menu, choose the Copy option.Go to the Home tab after selecting the entire data.Here are the easy to follow steps for converting columns to rows: Changed orientation will help us in comparison.

This data is presented in horizontal order, whereas we need this data to be in the vertical orientation. Let’s grab details with examples! Excel Flip Rows and Columns with Copy and Pasteīelow in this image, you can see the sales data location-wise. Two major methods are described here for Excel flip rows and columns. Well, below you will find some differences that let you decide which method you should use. For instance, this function could be used in Excel formulas or with paste options. The transpose function is purely handy as well as versatile. Using the transpose function let your data change its orientation such as the vertical range of your columns’ orientation and the horizontal range of your rows’ orientation. In Excel, you can use multiple methods for Excel flip rows and columns.īefore diving into the explanation of methods, let’s have a look at what is Transpose function used in Excel. In this case, you will have to transpose Excel data to accommodate your preference. For instance, if an Excel spreadsheet has data in horizontal cells, it might be possible that your boss prefers that data to be flipped vertically. Converting column data into rows and rows’ data into columns merely requires you to follow simple steps. Having data in rows might be sometimes needed to flip into columns or vice versa. As you know that people look at Excel data in their own way.

Transform columns to rows in excel