Merging data from excel to word

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

Hi

I have a 5 row, 4 column table in Word that is part of a larger layout. In
Excel I have a 5 column spreadsheet with about 150 rows. I need the 5
fields in the spreadsheet (i.e which represent one complete row) to come
into each of the COLUMNS in Word, ie. the first column would contain field
1, field 2, field 3, field 4 and field 5 - each in the 5 rows of the first
column. Then each of the next 3 columns on the page would contain the next
5 fields (which represent 1 complete row) from the spreadsheet.

I've tried doing a data merge and placing the field codes in the five rows
of the first column in Word. To try to get it to work I added a sixth row
and inserted a <<next record>> field code, hoping that this would allow
the next column to be populated with the next row of the spreadsheet. I
also duplicated all the field codes from the first column and pasted them
into the other 3 columns.

This method isn't working though.

When I do a merge to a separate do***ent, the first column is getting
populated correctly but the remaining 3 columns are just duplicates of
this first column instead of being populated with the records from the
next three rows from the spreadsheet.

I wondered if someone could tell me how I can get it working correctly -
if it's possible at all.

Thanks