Verticalize a Table in Excel

Do you have a wide Excel table with years listed in its top row? Want to transform it into a tall Excel table with years listed in a column?

Verticalize a Table in Excel

Do you have a wide Excel table with years listed in its top row? Want to transform it into a tall Excel table with years listed in a column?

You can! Try my VBA macro verticalize. I created it to quickly transform summary tables that have year, month, day, or some other time data listed across the top into tables with that same time data listed in a column. Once your data is in a column, you can more easily manipulate the data in a pivot table or database to reach your project goals.

If you already feel comfortable with VBA macros, then you can copy and paste from GitHub. Otherwise, download the sample Excel file below and watch the video demonstration. Either way, you can adapt this method to any data that you are working with.

Sample data for this project were downloaded from the World Bank website on July 16, 2022.

Want to do this in reverse i.e., transform a table from long and tall to short and wide? Use a pivot table or try my VBA macro horizontalize.