Importing Text and Combining Every other Row

J

Jeff W

I am bringing data in from a report. The report has the data listed on two seperate rows. Is there anyu way in Excel that I can combine these two rows into one? If not, is thre an easy way to delete every other row?

Thank you!
 
D

Dave Peterson

Is the data all in one column?

If yes, you can put every other row in columns B and C by using a formula like:

=INDEX(A:A,ROW()*2-1)
(in B1)
=INDEX(A:A,ROW()*2)
(in C1)

Drag down as far as you need.

copy|paste special|values and delete column A).

=======
If you want to delete every other row:
Insert a new column A (or use an empty column)
In A1, put A (just the letter)
in A2, put B (just the letter)

Select A1:A2 and drag down the column. Sort by that column and delete all the
B's.

delete that helper column.
 
Top