cut and paste

[bob_man_uk]

hi all,

explanation: i have a spreadsheet with a list of part numbers, each part number has been tested and has come up with some results which have been put into a spreadsheet, all the information is listed underneath each other

what I need: I want to cut and paste all the info from underneath each other, to the end of the preceding line of data note: some data has 1,2,or 3 lines of data underneath

what i want to know: can it be done and can you help me do it.

cheers
mattyg

 

[markjarvisltd]

Its a little difficult to understand your exact needs
Try using html maker to show what you have and what you want to achieve

 

[bob_man_uk]

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2				testone					testtwo
3	1B0809	10		TURN&BORE(CONT)	5927	HERBERTAL20	52.5	3.1	FACETOWIDTH(CONT)	5927	HERBERTAL20	36.36	2.2
4	1B0809	20
5
6	1B0810	10		TURN&BORE(CON)	5927	HERBERTAL20	63	8
7	1B0810	20		FACETOWIDTH	5927	HERBERTAL20	52.5	7
8
Sheet1

ok as the above shows there are four lines of data these are two different parts, the data was filed underneath one another, the top half has already been separated (this was done manually) and the bottom half needs doing, now this is just a sample but this goes on for a hell of a long way and this is only two sets of tests, some have 3, some only have one