Need to create new unique data set by combining ID1 & ID2, with no common key

[l2decker]

I have two tables of data that are completely different, but I need to merge them, repeating the data from ID 2 for each one of the unique identifiers in ID 1.

The combination will allow for downstream calculations. 

[Qiu]

@l2decker 
It seems to be a typical use case for Append tool.

Can you give a try?

[CarliE · Accepted solution]

@l2decker 

Attached is a workbook!

Please mark a solution in which you found helped to solve your problem.

Thanks :)

[l2decker]

Thank you, that worked perfectly!