Change the rows to the columns
 

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

Change the rows to the columns
 

Hi Nikki,

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

Paste special Transpose

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568798

Change the rows to the columns
 

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?

"oldchippy" wrote:


Hi Nikki,

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

Paste special Transpose

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=568798