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

20/11/12	RT	RT448	Stent Abdominal Aorta	C6073	C6073	TUE	C6073	C3118	M	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.
20/11/12	RT	RT448	Stent Abdominal Aorta	C6073	C6073	TUE	C6073	C3118	M	Clinical History : Inflammatory 9cm AAA. Unsuitable for open surgery or fenestrated EVAR. Planned left renal chimney and right renal sacrifice.
24/06/12	RT	RT4031	Embolisation	C3162	C3162	SUN	C3162		F	embolisation was performed to the left g
24/06/12	RT	RT4031	Embolisation	C3162	C3162	SUN	C3162		F	Clinical History : upper GI

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

 

[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.

20/11/12	RT	RT448	Stent Abdominal Aorta	C6073	C6073	TUE	C6073	C3118	M
20/11/12	RT	RT448	Stent Abdominal Aorta	C6073	C6073	TUE	C6073	C3118	M	Clinical History : Inflammatory 9cm AAA. Unsuitable for open surgery or fenestrated EVAR. Planned left renal chimney and right renal sacrifice.	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.
24/06/12	RT	RT4031	Embolisation	C3162	C3162	SUN	C3162		F
24/06/12	RT	RT4031	Embolisation	C3162	C3162	SUN	C3162		F	Clinical History : upper GI	embolisation was performed to the left g

<colgroup><col style="width:65pt" width="65"> <col style="width:65pt" span="11" width="65"> </colgroup><tbody>
</tbody>