AnsweredAssumed Answered

Combine 2 Lines with the same ID

Question asked by diji.ng522351 on Jul 6, 2016
Latest reply on Jul 1, 2017 by antonypaul.alexj438051

Hi All,

 

Refer to the data example below.

Capture11.JPG

I have a table of data as above and I would like to combine the Office Phone No and Mobile Phone No with  the same Employee Number. The output result should as below.

Capture13.JPG

Is there any method to combine the lines of record as above?

 

 

Thank you.

Outcomes