Help - copy and paste basic quick fix

[joewood]

Hi
I have a large data base that has duplicate data on several rows - except for a single cell value.
I need to copy this one unique cell to the cell after the row below (that has the 'near identical' data).
Its not just 'cut and paste to one cell down and one cell across' as sometime there are 3 rows of repeated data (and hence 3 unique cell values I need).
Other than just dragging the cell value across (which is going to take forever as there is so much data) is there a simple way of either automatically selecting to cut and paste across?
Regards
and thanks

Joe
small exerpt from database below

[TABLE="width: 1387"]
<colgroup><col span="3"><col span="7"><col></colgroup><tbody>[TR]
[TD="align: right"]20/11/12[/TD]
[TD]RT
[/TD]
[TD]RT448
[/TD]
[TD]Stent Abdominal Aorta
[/TD]
[TD]C6073
[/TD]
[TD]C6073
[/TD]
[TD]TUE[/TD]
[TD]C6073
[/TD]
[TD]C3118
[/TD]
[TD]M
[/TD]
[TD]Stent Graft Abdominal Aorta : G.A. via right CFA deployed just extend to distal left CIA. 16 - 56 EVAR limb to extend to distal right CIA. ACT maintained at target o.
[/TD]
[/TR]
[TR]
[TD="align: right"]20/11/12[/TD]
[TD]RT
[/TD]
[TD]RT448
[/TD]
[TD]Stent Abdominal Aorta
[/TD]
[TD]C6073
[/TD]
[TD]C6073
[/TD]
[TD]TUE[/TD]
[TD]C6073
[/TD]
[TD]C3118
[/TD]
[TD]M
[/TD]
[TD]Clinical History : Inflammatory 9cm AAA. Unsuitable for open surgery or fenestrated EVAR. Planned left renal chimney and right renal sacrifice.
[/TD]
[/TR]
[TR]
[TD="align: right"]24/06/12[/TD]
[TD]RT
[/TD]
[TD]RT4031
[/TD]
[TD]Embolisation[/TD]
[TD]C3162
[/TD]
[TD]C3162
[/TD]
[TD]SUN[/TD]
[TD]C3162
[/TD]
[TD][/TD]
[TD]F[/TD]
[TD]embolisation was performed to the left g
[/TD]
[/TR]
[TR]
[TD="align: right"]24/06/12[/TD]
[TD]RT
[/TD]
[TD]RT4031
[/TD]
[TD]Embolisation[/TD]
[TD]C3162
[/TD]
[TD]C3162
[/TD]
[TD]SUN[/TD]
[TD]C3162
[/TD]
[TD][/TD]
[TD]F[/TD]
[TD]Clinical History : upper GI
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jamtay317]

I dont understand what you are asking could you please show a sample of what you are looking for after the macro runs

 

[joewood]

Sorry

I would just like this sort of arrangement
The value in column 3 tells me if the similar rows relate to each other and thus should be brought together into a single row. Sometime there are 3 or 4 rows with the end cell being the only difference but these needing to be merged into a single row.
Ive tried using a macro to cut and paste one cell across and one cell down but I just can t get it to work as Im a real novice at this sort of thing.

Thanks for your time on this.



[TABLE="width: 780"]
<colgroup><col style="width:65pt" width="65"> <col style="width:65pt" span="11" width="65"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 65"]20/11/12
[/TD]
[TD="class: xl64, width: 65"]RT[/TD]
[TD="class: xl64, width: 65"]RT448[/TD]
[TD="class: xl64, width: 65"]Stent Abdominal Aorta[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]TUE[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]C3118[/TD]
[TD="class: xl64, width: 65"]M[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD="class: xl63, width: 65"]20/11/12[/TD]
[TD="class: xl64, width: 65"]RT[/TD]
[TD="class: xl64, width: 65"]RT448[/TD]
[TD="class: xl64, width: 65"]Stent Abdominal Aorta[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]TUE[/TD]
[TD="class: xl64, width: 65"]C6073[/TD]
[TD="class: xl64, width: 65"]C3118[/TD]
[TD="class: xl64, width: 65"]M[/TD]
[TD="class: xl64, width: 65"]Clinical History : Inflammatory 9cm AAA. Unsuitable for open surgery or fenestrated EVAR. Planned left renal chimney and right renal sacrifice.[/TD]
[TD="class: xl64, width: 65"]Stent Graft Abdominal Aorta : G.A. via right CFA deployed just extend to distal left CIA. 16 - 56 EVAR limb to extend to distal right CIA. ACT maintained at target o.[/TD]
[/TR]
[TR]
[TD="class: xl63, width: 65"]24/06/12[/TD]
[TD="class: xl64, width: 65"]RT[/TD]
[TD="class: xl64, width: 65"]RT4031[/TD]
[TD="class: xl64, width: 65"]Embolisation[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"]SUN[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"][/TD]
[TD="class: xl64, width: 65"]F[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, width: 65"]24/06/12[/TD]
[TD="class: xl64, width: 65"]RT[/TD]
[TD="class: xl64, width: 65"]RT4031[/TD]
[TD="class: xl64, width: 65"]Embolisation[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"]SUN[/TD]
[TD="class: xl64, width: 65"]C3162[/TD]
[TD="class: xl64, width: 65"][/TD]
[TD="class: xl64, width: 65"]F[/TD]
[TD="class: xl64, width: 65"]Clinical History : upper GI[/TD]
[TD="class: xl64, width: 65"]embolisation was performed to the left g
[/TD]
[/TR]
</tbody>[/TABLE]