How to Integrate Client Data

[Manny74]

Hi, I am trying to integrate this, I have 1 client with their latest appointment on 1 row.

How would I do this?

A	B	C	D
DOE, JOHN	02/14/2018	3 mos.	01/01/2018
DOE, JOHN	02/14/2018	3 mos.	05/01/2018
DOE, JOHN	02/14/2018	3 mos.	03/21/2018
A	B	C	D
DOE, JOHN	2/14/2018	3 mos.	5/01/2018

<tbody>
</tbody><colgroup><col><col span="3"></colgroup>

 

[jtakw]

Hi,

That's as vague a question as it gets, "How would I do this?", can you please explain what "this" means.

 

[Manny74]

I need help figuring out how to delete duplicated clients while keeping his/her last appt....
So instead of highlighting the row for each duplicated client and deleting it, I need help figuring out how to best do this, as I have hundreds of duplicated clients with multiple appts....
Ideally I'd like it to look like below:


Data starts out like this:

A	B	C	D
DOE, JOHN	02/14/2018	3 mos.	01/01/2018
DOE, JOHN	02/14/2018	3 mos.	05/01/2018
DOE, JOHN	02/14/2018	3 mos.	03/21/2018
Data to look like this:
A	B	C	D
DOE, JOHN	2/14/2018	3 mos.	5/01/2018

<tbody>
</tbody>

Hi,

That's as vague a question as it gets, "How would I do this?", can you please explain what "this" means.