I have one list of 1333 part numbers and a second list of 92 approved suppliers… which will eventually yield an upload of 122,636 records (more than a single Excel 2016 sheet can handle)
How can I make Excel explode these together so I have 2 uploads of 60k-ish each?
yeah, old eyes didn’t see that extra zero for 1,048,576. Even aside from that, though, cutting and pasting 92 groups of the same part number and then adding the suppliers is tedious.
I didn’t get the the funnest part… there is another group of 8,501 part numbers and 509 suppliers. Over 4 million records on that one. Oh well. Thanks!
Your original question of to make " Excel explode these together " is how to make all the combos in a single worksheet?
Have three sheets.
Sheet one has the Parts with a row number column in the first column
Sheet two has the Vendors with a row number column in the first column
Sheet three has a row of formulas that increment the Supplier’s row num from 1 to count of suppliers, and part column row num increments every time the vendor row resets back to 1.
The third sheet the uses vlookups to find the PartNums and Vendors for the various combinations