Importing Text and Combining Every other Row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 
Back
Top