Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to combine every alternate row into one row combined - Excel
In F3 you put =OFFSET(A$3,(ROW()-ROW(A$3))*2,). In H3 put =OFFSET(A$4,(ROW()-ROW(A$3))*2,0). [note the change of the first 3 to 4] These formulas should give you the first entry in a single row. Then copy the formulas down for as many rows as you need. When happy with the results you can copy...- 777ad777
- Post #4
- Forum: Microsoft: Office
-
How to combine every alternate row into one row combined - Excel
Hi, If someone can suggest a formula I would be very grateful! I have an excel sheet I am trying to edit with over 500 rows of entries. I couldn't get an CSV file so I have copied it from a Word document so it split up the information into 2 rows. I need to combine every second row into the...- 777ad777
- Thread
- Replies: 8
- Forum: Microsoft: Office
