Thread: How can I delete every 3rd row/add 'by'/combine ever two rows (besides doing it manually)
View Single Post
 
Old 12-02-2016, 09:51 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote