Power Query: Generate All Possible Combination Of Items From Two Lists

preview_player
Показать описание
Here's another slightly more direct way of getting all possible combinations of items from two list with Excel's power query (Get & Transform Data in Excel 2016).

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!
  1. How To Excel
  2. Microsoft Excel
  3. Excel
  4. Microsoft
  5. Tutorials
  6. Power Query
Рекомендации по теме
Power Query: Generate 0:03:07

Power Query: Generate All Possible Combination Of Items From Two Lists

Get all possible 0:12:29

Get all possible combinations from multiple lists in Excel using Power Query | Excel Off The Grid

Easy Way to 0:12:54

Easy Way to Create ALL Possible Combinations From Multiple Lists in Excel (Power Query & Formula...

Create All Possible 0:16:41

Create All Possible Combinations from Two or More Lists in Power Query

How to use 0:16:35

How to use Microsoft Power Query

Power Query - 0:01:04

Power Query - How to return to the Query Editor

Excel: Split & 0:00:43

Excel: Split & Group Data with Power Query

Combine Files from 0:10:18

Combine Files from a Folder with Power Query the RIGHT WAY!

Running Totals with 0:03:34

Running Totals with a Condition - Power Query Challenge 48

INSANE AMAZING Power 0:05:38

INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

7 Power Query 0:24:05

7 Power Query Tricks You’ll Regret Not Knowing

How Power Query 0:09:02

How Power Query Will Change the Way You Use Excel

Learn Power Query 0:18:45

Learn Power Query & Automate Boring Data Tasks in 15 Minutes!

List.Generate() Function and 0:23:56

List.Generate() Function and Looping in PowerQuery

How to Use 0:18:27

How to Use List Generate to Make API calls in Power Query

Power Query Replaces 0:01:00

Power Query Replaces XLOOKUP?!

Get Multiple Files 0:08:49

Get Multiple Files Containing Multiple Sheets with Power Query

How To Generate 0:04:09

How To Generate All Possible Combination Of Items From Two Lists

Copy queries in 0:04:20

Copy queries in Power Query for Power BI or Excel

2 Tricks to 0:08:06

2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7

Listing all Functions 0:03:24

Listing all Functions in the Power Query Editor

How To Easily 0:09:35

How To Easily Merge Tables With Power Query: Vlookup Alternative

'#section' Trick in 0:00:49

'#section' Trick in Power Query 🔥

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

FINALLY!! Someone make it simple and clear. Thank you!

andreferrari
Автор

Thanks for sharing this valuable knowledge and for make it very simple and objective to learn.

rafaelbandeira
Автор

Hello there
I liked the way you have educated in this video, i need to know a little more of this concept if you could help me out. I want to write all possible combinations of a 6 number lottery ranging between 1 to 45.
I hope you understand what i am trying to say, i mean how can we write every single possible combination of 6 numbers from 1 to 45 in excel.
If there is any answer to it, do reply. I want to write all 87, 45, 060 combinations in excel.

rodycricket
Автор

If there are 3 or more lists, how to do it?

anhnhatnguyet