Can I assign multiple unique ID's to a group or table? Odd technicality...

[MMADURA]

Hello All - I have been reading this forum for a long, long time; finally, I decided to post something that is completely vexing me! I am running Excel 2010.


I am working within our database [Salesforce] and I pulled a list of products into excel - they are bundled into groups of 24. There are 5 columns in the Bundle consisting of Product and Bundle ID's.

I need to attach a list of 2000 Order ID's to each grouping (Bundle) of 24. There is only one bundle not multiple bundles. Essentially, the bundle id's are in columns A thru E and the Order Id's I need to attach to them all are in Column G. I need Order ID in Column G to be attached to all 24 lines creating in the end a list of 49k+ lines [24*2000]

I tried naming the group and assigning our unique id's but was not able to do that - I am not an excel guru by any means, but I know my way around a few key formulas...

Any help would be greatly appreciated!