Organizing data automation

Hi, I have thousands of rows to organize which seems and impossible task to do manually. I have email and phone number alternating in one column. What I need is to put them into two separate columns, copying the phone number from eg D3 and pasting it into E2, then deleting the empty row. Tried lots of things, no idea how to do it except manually, please help. See the attached file, it's hard to explain exactly.

helpme.png
AttachmentSize
helpme.xls17.5 KB
Nick's picture

steps: - in cell E2, put this

steps:

- in cell E2, put this formula: =D3
- in cell E4, put this formula: =D5
- select range D2 to D5
- click on cross at the bottom right hand of the selection
- drag it down as far as your data
- select column e
- copy and paste special values
- select all the data on the sheet
- sort by Name
- all the coloured cells in col D will move to the bottom
- delete those cells

thanks, you saved my day

thanks, you saved my day