Hi,

I have a table that looks like:
Site A Site B Site C
Site Code XXX XXX XXX
Field Team XXX XXX XXX
Site Address XXX XXX XXX
Site Type XXX XXX XXX

I would like to change it to:
Site Code Field Team Site Address
Site Type
Site A XXX XXX XXX
XXX
Site B XXX XXX XXX
XXX
Site C XXX XXX XXX
XXX

The reason I would like to do this is so I can merge to Word with info about
each Site (A, B, C) on a separate page. Does anyone know how to change the
rows to columns as above or an easier way to get it to merge properly?

Thanks

Nikki