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?

[TABLE="width: 432"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]01/01/2018[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]05/01/2018[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]03/21/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]2/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]5/01/2018[/TD]
[/TR]
</tbody><colgroup><col><col span="3"></colgroup>[/TABLE]

 

[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:
[TABLE="class: cms_table, width: 432"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]01/01/2018[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]05/01/2018[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]02/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]03/21/2018[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Data to look like this:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]DOE, JOHN[/TD]
[TD]2/14/2018[/TD]
[TD]3 mos.[/TD]
[TD]5/01/2018[/TD]
[/TR]
</tbody>[/TABLE]

Hi,

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