Excel: Swapping (reversing) the Axis of a Table Data

Standard

Data preparation (or call it pre-processing) is an essential and time-consuming part of any data analytic’s project. To that end, I was working on a data set needed some changes before I could plot it on an effective data visualization. Here’s what I did:

My Challenge:

I was working on a data set that looked like this:

DateAbu Dhabi, United Arab EmiratesAdalaj, Gujarat, IndiaAddison, TX
1/1/2013142
1/2/2013142
1/3/2013143
1/4/2013333
1/5/2013224
1/6/2013234
1/7/2013233
1/8/2013224
1/9/2013223

BUT: I wanted my data to look like

Date1/1/20131/2/20131/3/20131/4/20131/5/20131/6/20131/7/20131/8/20131/9/2013
Abu Dhabi, United Arab Emirates111322222
Adalaj, Gujarat, India444323322
Addison, TX223344343

What did my real data looked liked?

it has 380 columns and 500+ Rows and so MANUAL copy pasting was NOT an option!

Excel 2010 Solution:

It’s so simple!

Step 1: Select the data > COPY (Shortcut: ctrl + c)

Step 2: Switch to a new/different excel sheet

step 3: Paste Special > Transpose (T)

excel paste special transpose swap axis data

So After doing this, This is how the Input & output looks:

excel paste special reverse axis

Conclusion:

In this post, We saw how to swap or reverse the axis of a table data in Excel 2010.

What do you think? Leave a comment below.