Power Query lets you perform a series of steps to transform your Excel data.  One of the steps it allows you to take is to transpose data very easily.

Transposing a data table is basically rotating your data from rows to columnsor from columns to rows. To further explain this concept, screenshots are provided below.

Transpose Using Power Query | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

 

Let’s go through the steps in detail:

STEP 1: Select your data and turn it into an Excel Table by pressing the shortcut Ctrl + T or by going to Insert > Table

Transpose 01

 

STEP 2: Go to Data > Get & Transform > From Table (Excel 2016) or Power Query > Excel Data > From Table (Excel 2013 & 2010)

Excel 2016:

 Transpose 02

Excel 2013 & 2010:

from table

 

STEP 3: This will open up the Power Query Editor.

We want to rotate this data from rows to columns.

Transpose 03

 

STEP 4: Within here you need to select Transform > Transpose

Transpose 04

 

STEP 5: Now you will see your changes take place.

Transpose 05

 

STEP 6: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the transposed data.

Transpose 06

You now have your new transposed table.

Transpose 07

 

 

HELPFUL RESOURCE: 

Oz_Podcast_Banner

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn