Gather data in a single line

[imran ashraf]

[FONT=&quot] My problem is that each employee appears in the table for each month and I need to gather the data for each employee in a single line.
[/FONT]

Last Name	First Name	Location	Employment Date	Termination Date	1-Mar-2016	1-Apr-2016	1-May-2016	1-Jun-2016	1-Jul-2016	1-Aug-2016
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABAZA	VIOREL	VASLUI	5/19/2016			FALSE	TRUE	TRUE	TRUE	TRUE
ABIBULA	IZMET	CONSTANTA	6/4/2015	7/16/2016		TRUE	TRUE	TRUE	TRUE	FALSE
ABIBULA	IZMET	CONSTANTA	6/4/2015	7/16/2016		TRUE	TRUE	TRUE	TRUE	FALSE
ABIBULA	IZMET	CONSTANTA	6/4/2015			TRUE	TRUE	TRUE	TRUE	TRUE
ABIBULA	IZMET	CONSTANTA	6/4/2015			TRUE	TRUE	TRUE	TRUE	TRUE
ABIBULA	IZMET	CONSTANTA	6/4/2015			TRUE	TRUE	TRUE	TRUE	TRUE
ACSINIA	CATALIN	BUCURESTI	10/24/2016			FALSE	FALSE	FALSE	FALSE	FALSE
ADAM	CONSTANTIN GHEORGHE	MEHEDINTI	5/30/2015	6/11/2016		TRUE	TRUE	TRUE	FALSE	FALSE
ADAM	CONSTANTIN GHEORGHE	MEHEDINTI	5/30/2015	6/11/2016		TRUE	TRUE	TRUE	FALSE	FALSE
ADAM	CONSTANTIN GHEORGHE	MEHEDINTI	5/30/2015			TRUE	TRUE	TRUE	TRUE	TRUE
ADAM	CONSTANTIN GHEORGHE	MEHEDINTI	5/30/2015			TRUE	TRUE	TRUE	TRUE	TRUE
AFRIM	IUSTIN-GEORGE	BISTRITA	1/1/2016	3/2/2016		FALSE	FALSE	FALSE	FALSE	FALSE
AIOANEI	IOAN	ROMAN	6/6/2015	7/1/2016		TRUE	TRUE	TRUE	TRUE	FALSE
AIOANEI	IOAN	ROMAN	6/6/2015			TRUE	TRUE	TRUE	TRUE	TRUE
AIOANEI	IOAN	ROMAN	6/6/2015			TRUE	TRUE	TRUE	TRUE	TRUE
AIOANEI	IOAN	ROMAN	6/6/2015			TRUE	TRUE	TRUE	TRUE	TRUE

<colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[iliace]

As long as your most recent date appears at the top, you can use Remove Duplicates for Last Name, First Name combination (possibly also Location and Start Date). Look under the Data -> Data Tools menu.