Use the Unpivot Feature in Power Query

[@MrSemyonoff]

This trick with Transpose and all the other stuff after that were amazing! Good job, many thanks for sharing this!

[@DougHExcel]

You’re welcome

[@zvibernstein7055]

Thanx! The nested headings was a big help. It save hours of work and showed how to use a whole bunch of other time saving techniques

[@DougHExcel]

Thanks Zvi Bernstein, glad it helped!

[@excelisfun]

unpivotingly awesome!

[@MrSemyonoff]

It was FUN to read your comment here! Love your videos, Mike! All I know about Power Query, I've learned from your great videos!

[@nitishkarnatakam8350]

This made my office work easy. I was struggling with VBA macros to transform the data.Seriously, power query has made my life easier and excellent video, Doug. Thanks a Ton square.

[@DougHExcel]

Hi Nitish Chowdary, glad you liked it, thanks for commenting! Power Query is awesome!

[@nitishkarnatakam8350]

Doug,Hi Doug, Can I get any of the videos related building graphs using power query?

[@DougHExcel]

Power Query is more for cleaning up data that you can put back into Excel for charting. I've got some different charting video on my channel. See => kzbin.info/aero/PL-n8f1cY_Qw92K5pBxQ_H2Jh_k6vym62W

[@saiestamerch9998]

Thanks ! This is a great help and solved a big problem for me. Thanks a ton man !

[@DougHExcel]

Hi Saiesta Merch, thanks for the comment!

[@nuanhe9563]

Great job! what if I want to put 2013 and 2014 in two different columns? Is there an easier way to accomplish that?

[@DougHExcel]

Since you have a proper table after doing the unpivot, you can just make a pivot out of that and have the year in the column field.

[@LotfyKozman]

Good Job.

[@vudien2517]

Could you share the workbook?