Change the rows to the columns

[Guest]

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

 

[oldchippy]

Hi Nikki,

Copy your range of data, then in a different cell say F1

Paste special > Transpose

oldchippy

 

[Guest]

Hi,

Thanks. Tried that but realised that I actually need the data to be updated
in the original table. Is there a way to update the transposed data wen the
original data is changed?