Table U contains 1 field (Field F, primary key = no dupes)

Table N contains 50 fields (including Field F, same as in Table U)

* Field F in Table N contains multiple records, with dupe values

Would like to create a new Table (or just append to Table U), all values in Table N that match on Field F, but only with one record for each value of Field F. Here are sample layouts of the two Tables:

*Table U*

__Field F__

A

B

C

etc

*Table N*

__Field F__

__Field F1__

__Field 52__.....

__Field 10x__

A A1 A2 A5

A A2 A3 A3

A A3 A7 A8

B B1 B2 B3

C C1 C9 C7

C C1 C2 C4

Basically, I want to end up with the following:

*New Table*

__Field F__

__Field F1__

__Field 52__.....

__Field 10x__

A A1 A2 A5 A3 A7 A8

B B1 B2 B3

C C1 C9 C7 C2 C4

Where, there is ultimately 1 record per value in Field F, and each of the corresponding values from multiple records of Field F are added to the end of the one record, if that makes logical sense.

I have tried many different things, from INTERSECT, to CONCAT, to INNER JOIN, to OUTER JOIN, to LAST, but my SQL isn't good enough even to post here, as nothing really works. :)

Thank you so much in advance!

karin