Changing the format of a block of data
 

Hi
I have data which I have extracted from the web with a web query. It
looks like this:
A B C
Type: Unit/Apartment 1/85a Bream Street Saturday 9302 2333
Bed: 2 Coogee 9.30 - 10.15am
Bath: 1 Thursday
Parking: 1 9.30 - 11.15am

Type: Unit/Apartment 23/13 Hill St Saturday 9302 2333
Bed: 2 Coogee 9.45 - 10.30am
Bath: 2
Parking: 1

Each "block" of information is "formatted" the same with two blank
lines between them, each web page has twenty of these "blocks" they
are four rows deep and three columns wide. I have used a macro to
change the formatting of one "block" to a single row entry so the two
"blocks " above would be converted to this:
A B C D E F
1/85a Bream Street Coogee Saturday 9.30-10.15am Thursday 9.30-11.15
23/13 Hill Street Coogee Saturday 9.45 - 10.30am

I have quite a few hundred "blocks" of data to sort which I am
attempting to do with the macro is there a way to automate this
process or am I looking at the wrong method to reformat this data. I
understand there is a lookup function which may be able to be used but
the method of use for multiple "lookups" I cannot find
Thanks
Greg