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.
Attachment | Size |
---|---|
helpme.xls | 17.5 KB |
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