Thread: [Solved] rows in word?
View Single Post
 
Old 07-19-2012, 03:59 PM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

In Excel, if you put all the data into column A on Sheet1, the following formula in columns A & B on Sheet2 will generate the kind of output you're after:
=IF(OFFSET(Sheet1!$A$1,(ROW()-1)*2+COLUMN()-1,0)="","",OFFSET(Sheet1!$A$1,(ROW()-1)*2+COLUMN()-1,0))
If you add/delete rows on Sheet1, the formula will automatically rearrange the data. The only thing you'll need to ensure is that the formula in Sheet2 spans at least half the number of rows on Sheet1.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote