In this video I will show you how to create all possible combinations from two or more lists in Excel.
First I'll show you how to do this using a simple trick in Power Query, and then I'll also show you a formula to do this.
➡️ Download File - https://www.dropbox.com/scl/fi/3wfovv4p563naxafp9mti/Create-All-Combinations.xlsx?rlkey=7nqhlk0yhss7gebtdb65v17zf&dl=1
00:00 Intro
00:27 Create All Combinations using Power Query
07:43 Create All Combinations using Formula
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1
#Excel #ExcelTips #ExcelTutorial #SumitBansal