The above formula will produce a single column based on the left to right then down pattern. The above formula will produce a single column based on the top to bottom then right pattern.Īnother approach could be to start in row 1 column 1 and move across the columns until you reach the last column then move down to row 2 column 1 and start the pattern again until you cover the whole table like in the picture above. If you wanted to transform this into a single column of data you could start in row 1 column 1 and move down the rows until you reach the last row then move onto row 1 column 2 and start the pattern again until you cover the whole table like in the picture above. Here you will have the option of moving the row one place up or down, or moving it to the beginning or end of the list. To change the order, just right-click on row or column heading and go down to 'Move'.

Here you have a table with 3 columns and 4 rows. By default, Excel will list the rows and columns of a PivotTable in alphabetical order, but that may not be in the order that you want. Then, click and hold the green outline of your range (you must. If you wanted to move the Amount column before the Sales Rep column, you would simply select the column header. Going across the columns first then down the rows in your table. How to quickly rearrange columns in a data table in Excel 1.In the below example we have a two column data table.Going down the rows first then across the columns in your table.There are many ways you could transform a table into a single column but this post will explore the two ways that make the most sense. Scroll across your sheet to make sure the left column stays fixed. You should see a new menu with your 3 options. Get your copy of the example workbook with the above link. On the Freeze Panes button, click the small triangle in the lower right corner.

Moving columns in excel table