Professor Excel
Convert Table to Column in Excel

Convert Table to One Column in Excel: 4 Easy Methods to Copy All Columns underneath Each Other

Copy table to one column in Excel

Copy table to one column

Say you have an Excel table and want to copy all column underneath each other so that you only have one column. For example, you have a table 2 rows by 4 columns like in the screenshot on the right-hand side. You want to copy and paste this table to one column. You often need such transformation for inserting PivotTables or to create database formats. This article provides 4 simple methods to transform a 2-dimensional table into one column in Excel.


Adjust Rows and Columns in Excel: The 4 Best Ways!

Do you spend a lot of time changing the column width in Excel? On the one hand, you’d like to see as many columns as possible for having a good overview, but on the other hand, you want to see as much content as possible within a column. In the worst case, you’d only see ### instead of values.

How to Repeat Rows and Columns on Printouts

When you print a large table, you can select rows or columns which you want to repeat on each page. This way, the data is easier to read as the heading will be printed on each page.

How to Insert Rows and Columns

Let’s enhance your Excel skill with some handy keyboard shortcuts: How to insert a new row (or column) within 1 second without using the mouse?

Unhide all rows and columns at once in Excel.

Unhide All Rows or Columns in Excel at the Same Time

Many people love the “Hide” function for hiding rows or columns, as it is very easy to use:

Grouping and Hiding Rows and Columns in Excel

You got an Excel table with some unimportant rows, but you don’t want to delete them. In such case, you might want to “hide” them. There are two options of hiding rows (and columns): Either right-click on the row (or column) number and click on “Hide” or use the group function.