Use the Unpivot Feature in Power Query

  Рет қаралды 5,781

Doug H

Doug H

Күн бұрын

Пікірлер: 16
@MrSemyonoff
@MrSemyonoff 5 жыл бұрын
This trick with Transpose and all the other stuff after that were amazing! Good job, many thanks for sharing this!
@DougHExcel
@DougHExcel 5 жыл бұрын
You’re welcome
@zvibernstein7055
@zvibernstein7055 6 жыл бұрын
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
@DougHExcel 6 жыл бұрын
Thanks Zvi Bernstein, glad it helped!
@excelisfun
@excelisfun 8 жыл бұрын
unpivotingly awesome!
@MrSemyonoff
@MrSemyonoff 5 жыл бұрын
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
@nitishkarnatakam8350 7 жыл бұрын
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
@DougHExcel 7 жыл бұрын
Hi Nitish Chowdary, glad you liked it, thanks for commenting! Power Query is awesome!
@nitishkarnatakam8350
@nitishkarnatakam8350 7 жыл бұрын
Doug,Hi Doug, Can I get any of the videos related building graphs using power query?
@DougHExcel
@DougHExcel 7 жыл бұрын
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
@saiestamerch9998 7 жыл бұрын
Thanks ! This is a great help and solved a big problem for me. Thanks a ton man !
@DougHExcel
@DougHExcel 7 жыл бұрын
Hi Saiesta Merch, thanks for the comment!
@nuanhe9563
@nuanhe9563 7 жыл бұрын
Great job! what if I want to put 2013 and 2014 in two different columns? Is there an easier way to accomplish that?
@DougHExcel
@DougHExcel 7 жыл бұрын
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
@LotfyKozman 8 жыл бұрын
Good Job.
@vudien2517
@vudien2517 8 жыл бұрын
Could you share the workbook?
How to use excels new formulas to make an unpivot formula | LAMBDA
6:43
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18
CAN YOU DO THIS ?
00:23
STORROR
Рет қаралды 43 МЛН
😜 #aminkavitaminka #aminokka #аминкавитаминка
00:14
Аминка Витаминка
Рет қаралды 2,3 МЛН
Сюрприз для Златы на день рождения
00:10
Victoria Portfolio
Рет қаралды 2,7 МЛН
Combine CSV Files with Power Query
11:59
Doug H
Рет қаралды 17 М.
Merge Tables in Power Query
20:06
Doug H
Рет қаралды 18 М.
Power Query Unpivot - fix 4 common data layouts (incl. workbook)
19:24
MyOnlineTrainingHub
Рет қаралды 230 М.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 714 М.
Combine Excel Files with Power Query
12:47
Doug H
Рет қаралды 21 М.
How to easily automate boring Excel tasks with Power Query!
17:10
MyOnlineTrainingHub
Рет қаралды 1,6 МЛН
Friends make memories together part 2  | Trà Đặng #short #bestfriend #bff #tiktok
00:18