Hi,

Am Tue, 17 Jun 2014 16:23:40 +0100 schrieb TimR1316:

Title
Description
Blank Line
Title
Description
Blank Line

your data in Sheet1. then in Sheet2 A1:
=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*3+1)
and in B1:
=INDEX(Sheet1!$A:$A,(ROWS($1:1)-1)*3+2)
Copy both formulas down till you get zeros


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional