Combining multiple sets of data

G_SAND

Hi. As with most things I am sure this is easy!

I have 3 separate sets of data:

Part	Field 1		Part	Field 2		Part	Field 3
A	1		A	4		A	6
B	2		B			B	7
C	3		C	5		C

I want to combine so it reads:

Part	Field 1	Field 2	Field 3
A	1	4	6
B	2		7
C	3	5

I have tried a couple of things but can't seem to get it right.

Any help would be great.

Thanks

MarqueeCrew

JOIN MULTIPLE:

Part = Part = Part

Uncheck all duplicate part fields.

Done