How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)

		Microsoft Office Forums > Microsoft Excel > Excel
How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)

FAQ

Thread Tools

Display Modes

12-02-2016, 09:51 PM

macropod

Windows 7 64bit How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

Assuming your data are on Sheet1, starting in A1, you could create a new sheet and insert the following formula in A1:
=OFFSET(Sheet1!$A$1,(ROW()-1)*3,)&" by "&OFFSET(Sheet1!$A$1,(ROW()-1)*3+1,)
Copy that formula down as far as needed. No code required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

automation, combine data in rows, deleting a row

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do we add one or more rows manually( by typing row numbers). ?	Nawshoo	Excel	5	01-05-2016 02:15 AM
How to Delete the same watermark that are in 300 slides. I cant dare to manually delete.	yeshwanthkota111	PowerPoint	0	09-05-2015 10:03 AM
Macro to Combine Multiple Rows into One Row	brunssl2	Excel Programming	10	01-13-2015 01:56 PM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Do I manually delete messages after archiving to create space?	alshcover	Outlook	0	08-21-2014 10:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:11 AM.