I have two tables table1: list of unique Ids (list size is 3) and table2: list of items (list size is 3).
How could I create a third list where for each row in table 1 it adds all the rows from table2 with the unique id against it. So using the example numbers above we should end up with 9 rows, 3 rows for each unique id from table1.
Hope that makes sense, I also hope the below is readable!
Table1:
UID Header
UID1
UID2
UID3
Table2:
Header1 Header2
Name1 Value1
Name2 Value2
Name3 Value3
Expected Result:
UIDH Header1 Header2
UID1 Name1 Value1
UID1 Name2 Value2
UID1 Name3 Value3
UID2 Name1 Value1
UID2 Name2 Value2
UID2 Name3 Value3
UID3 Name1 Value1
UID3 Name2 Value2
UID3 Name3 Value3