Originally Posted by joeu2004[_2_]

"dpgreen" wrote:
I've attached an example of what I'm working with.
[....]
|Download: http://www.excelbanter.com/attachment.php?attachmentid=658|

Sorry, I did not see this response until long after I posted my previous
response.

Adapting to your example, enter the following formulas as indicated, then
copy down through row 11:

J6: =INDEX(B$6:B$24,3*ROWS(J$6:J6)+1)
K6: =INDEX(E$6:E$24,3*ROWS(K$6:K6)+1)
L6: =INDEX(F$6:F$24,3*ROWS(L$6:L6)+1)

If you would like those formulas to work as add data following row 24, enter
the following as indicated, then copy down as many rows as you like:

J6: =IF(INDEX(B$6:B$24,3*ROWS(J$6:J6)+1)="","",
INDEX(B$6:B$24,3*ROWS(J$6:J6)+1))
K6: =IF(INDEX(E$6:E$24,3*ROWS(K$6:K6)+1),"","",
INDEX(E$6:E$24,3*ROWS(K$6:K6)+1))
L6: =IF(INDEX(F$6:F$24,3*ROWS(L$6:L6)+1)="","",
INDEX(F$6:F$24,3*ROWS(L$6:L6)+1))

Obviously, it would be better if the values in columns E and F were unique
so that you could see that the formulas are "copying" the correct values.