Export data into word in a defined format

[droot]

Hi,

I'm trying to export a large dataset into Word and I don't know how to go about doing so.

Example -

Fruit	Q1	Q2	Q3	Q4	Q5
Apple	Respose1	Response2	Response3	Response4	Response5
Pear	Respose1	Response2	Response3	Response4	Response5
Banana	Respose1	Response2	Response3	Response4	Response5
Peach	Respose1	Response2	Response3	Response4	Response5

<colgroup><col style="width:42pt" width="56" span="6"> </colgroup><tbody>
</tbody>

I need the data to be presented in this format -

Apple

Q1
Response1

Q2
Respose2

...

Q5

Pear

Q1
Response1

etc
_

Any help will be greatly appreciated.

 

[droot]

Solved using Mail Merge