Combine 2 data set

[BosKev]

Hello,

How do I combine the 2 data point into one see below for example, thanks.

2 data point			Combine
Employee ID	Worksite		Employee ID	Worksite
123	ABC		123	ABC
			123	DEF
Employee ID	Worksite		123	GHC
123	DEF
123	GHC

[Felipe_Ribeir0]

Hi @BosKev 

You can do this using the union tool:

[martinding · Accepted solution]

 

Hi @BosKev 

Are these 2 data points from 2 separate files?

If you, you could simply use the Union Tool.

If they are in a single file, but in different rows, you could select the relevant rows first, then use the Union Tool.

[BosKev]

Thank you both