I need to create one sheet with two 'tables' on them. The data for the table is coming from only one cursor. I use the COPY TO ... TYPE XL5 from within FoxPro. I specify all required fields and Excel shows the each record in one row.

However I need to break up the rows, and repeat the first column from the first 'table' in the second 'table'
A coworker suggested a copy/cut-paste in the worksheet, this might work, I haven't tried it yet. I have a feeling that I should be able to spread the contents over ranges of cells, but I don't know how.

Can anyone give me any pointers?