Formula fill when there are constant number of spaces between data

[erm87]

Hello everyone,

Background: I have a set of .txt data I've imported into Excel. It came off a R232 serial port of a Fire Alarm Panel and isn't formatted in comma or tab or even a space delimited pattern. However it is consistently spaced (5 rows between data sets). Each little group (5 rows) of information is for a single Device on the system (ex. Smoke Detector) that has an Device Address, Type, and Description.

Problem: I'm trying to find, with no luck so far, a formula I can fill down that will take into account the spaced pattern.

What I've Tried: Well, being dumb, I first tried doing the first three devices by simple references and seeing if Excel would recognize the pattern -- Nope.
I then tried using the Offsets command like you see in the picture below, but that didn't work either -- it doesn't compound the offset amounts.

Goal: If I can get the devices into a nice list, I can then export a .csv to the Fire Alarm program and not have to manually enter each device (there are over 700 in total!).

Screenshot 2015-04-13 17.12.34.png

[JieJenn]

J3 enter =OFFSET($F$3,5*(ROW()-3),0)
K3 enter =OFFSET($H$3,5*(ROW()-3),0)
L3 enter = =OFFSET($B$3,(5*(ROW()-3)+1),0)&" "&OFFSET($B$3,(5*(ROW()-3)+1),1)&" "&OFFSET($B$3,(5*(ROW()-3)+1),2)&" "&OFFSET($B$3,(5*(ROW()-3)+1),3&" "&OFFSET($B$3,(5*(ROW()-3)+1),4))
M3 enter = =OFFSET($B$3,(5*(ROW()-3)+2),0)&" "&OFFSET($B$3,(5*(ROW()-3)+2),1)&" "&OFFSET($B$3,(5*(ROW()-3)+2),2)&" "&OFFSET($B$3,(5*(ROW()-3)+2),3)&" "&OFFSET($B$3,(5*(ROW()-3)+2),4)&" "&OFFSET($B$3,(5*(ROW()-3)+2),5)