cut and paste

bob_man_uk

Board Regular
Joined
Jul 28, 2004
Messages
106
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

markjarvisltd

Board Regular
Joined
Sep 17, 2004
Messages
92
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

Board Regular
Joined
Jul 28, 2004
Messages
106
Book1
ABCDEFGHIJKLM
1
2testonetesttwo
31B080910TURN&BORE(CONT)5927HERBERTAL2052.53.1FACETOWIDTH(CONT)5927HERBERTAL2036.362.2
41B080920
5
61B081010TURN&BORE(CON)5927HERBERTAL20638
71B081020FACETOWIDTH5927HERBERTAL2052.57
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
 

Forum statistics

Threads
1,148,272
Messages
5,745,791
Members
423,973
Latest member
man_this_is_hard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top