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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i combine excel worksheets 1
Delete rows based upon a range of times 5
reference every other row 2
Inserting rows slow on large report 6
Getting "Per Item" Pivot Chart Results when data rows are identica 4
Combining Rows on a label 1
Macro for hiding zero data rows while printing 1
Copy from Two Cells 5

Back
Top