How to delete a single line in each cell/row and keep the second line. Mass oper

[devaguptam]

Hi,


I have the below problem in my office.


I need to extract the content in the second line of each row in a sheet. Below is a sample of the content which i have in each row of a column. If you paste this in an excel you will see that both lines cme under same row. I am planing to record a macro but the macro is not giving correct output and i am having trouble deleting the top line of the row when recording a macro. Please help me with this problem.


"content in first line of the row

content in secong line of the same row"


What are the possible solutions for this.


Thanks,

Dev

 

[Hui]

In a spare Column, Row 1, put a =row()

In another spare Column, Row 1, put a =Mod(row(),2)

Copy down to the bottom of your data

Copy and paste these new columns as values

Sort all the data by the =Mod(row(),2) Column

You will now have a group of rows with 0 and another group with 1's

Delete the rows you don't want

Sort by the =row() column

Delete the two new columns