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).
http://www.howtoexcel.org/power-query... 👇
Check out my full courses and ebooks here
👉 https://www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 https://www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!