Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade Data

preview_player
Показать описание

Learn how to create a Proper Data Set from non-normalized data (like a cross tabulated table that does not have the correct field names) using the Unpivot Columns feature in Power Query:
1. (00:11) Problem Setup
2. (01:18) Grade Data Table Example
3. (03:29) Sales Table Example
4. (04:23) Create 3 PivotTables
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:05:44

Excel Magic Trick 1223: Power Query UnPivot Feature to Create Proper Data Set For Sales & Grade ...

Excel Magic Trick 0:06:49

Excel Magic Trick 1222: Formula To Add 10kg, 6kg, 19kg: Array Formula Or Custom Number Format?

Excel Magic Trick 0:05:26

Excel Magic Trick 1216: Fraction Number Formatting To Show Only Significant Digits, Like: ####/####

Excel Magic Trick 0:08:57

Excel Magic Trick 1224: Which Similar Array Formula? Compare Number of Array Operations

Excel Magic Trick 0:04:17

Excel Magic Trick 1219: Paste Special Linked Picture so PivotTable is not Hidden When Filter Applied

Excel Magic Trick 0:08:46

Excel Magic Trick 1234: VLOOKUP to 36 Different Tables: Helper Column w LOOKUP & Expandable Rang...

Excel Magic Trick 0:02:22

Excel Magic Trick 1421: Get Help for Power Query Functions

Excel Magic Trick 0:10:41

Excel Magic Trick 1243: Transform GDP Data Set: Power Query 2nd Method or Advanced Filter?

Excel Magic Trick 0:18:43

Excel Magic Trick 1357: Power Query Function to Repeat Clean & Transform Steps for Many Excel Fi...

Excel Magic Trick 0:08:57

Excel Magic Trick 1221: Dynamic Chart to Plot Daily Changes in Meter Readings

Excel Magic Trick 0:11:22

Excel Magic Trick 1403: DAX Formulas: Explicit or Implicit Measures? Why Explicit is Better.

Excel Magic Trick 0:14:21

Excel Magic Trick 1231: VLOOKUP to 36 Different Tables: CHOOSE, OFFSET or INDIRECT function?

Excel Magic Trick 0:07:20

Excel Magic Trick 1227: Conditional Format: Min, Max & Min Value Greater Than Zero

Excel Magic Trick 0:09:36

Excel Magic Trick 1238: Are All Cells Equal? Is The Content In Each Cell The Same? 4 Examples

Custom Excel Workshops 0:02:25

Custom Excel Workshops - Unpivot Tables

Excel Magic Trick 0:11:29

Excel Magic Trick 1250: Add Times to Get Total Minutes & Seconds From Downloaded Music Data

Index multiple result 0:02:53

Index multiple result in single Cell Excel formula

How To Build 0:03:32

How To Build Sample sheet Parameter

Excel Power Query 0:07:31

Excel Power Query #10: UnPivot Feature to Create Proper Data Sets (2 Examples)

Power Query: Group 0:02:36

Power Query: Group and transpose by unique Key

How to Use 0:07:40

How to Use UNPIVOT in EXCEL (Power Query)

EP 02 | 0:09:38

EP 02 | Flat Table vs Cross Table

Combine Excel Worksheets 0:08:02

Combine Excel Worksheets in Power Query

Convert Summarized Table 0:05:21

Convert Summarized Table To Proper Data Set With Power Query!

Комментарии
Автор

Watched the whole Excel Power BI series! This is a gold mine of knowledge! Thank you and the team for all the effort, highly appreciated!

sherifelgamal
Автор

Thanks for the refresher Mike. This solves my issue tomorrow at work....much

mattschoular
Автор

Lotfy Kozman, I cannot respond to your comments at YouTube. It may be because of your channel settings? Anyway, I do not have many plans to do videos on Power Pivot and Power Query until late next year. This is because I have many duties piled on me at work. I look forward to getting to the Power BI as soon as I can, though...

excelisfun
Автор

Hmmm, We just started to restore our strength. Also, very eager to see your new videos about Power BI as well.

LotfyKozman
Автор

Great! Thanks to You and Bill Szysz :)

pmsocho
Автор

Great video!  I learn so much from this channel,

davidg
Автор

Sir, how could we change the data format from row to columns in power query? I mean unpivot columns to pivot columns. Your help in this regard is highly appreciated.

Dipakbohora
Автор

how about if my data is too large and i can not get the data transform to excel as all?

talebbagazi
Автор

Power query is available only form Excel 2013 onward? If yes what is the solution for Excel 2007?

planiolro