I would like to use Access in order to duplicate the content of a list of values into new rows based on the content of a column. Here is an example below: List1 List2 A 1 B 2 C 3 D 4 E 5 F 6 G 7 Duplication A1 A2 A3 A4 A5 A6 A7 B1 B2 B3 B4 B5 B6 B7 Etc How can I achieve this in Access?