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