transpose a table

S

SuzyQ

I have been asked to keep a document up to date. I am given a document with
the information going across from columns A through BD. This obviously
cannot be printed on one page. I would like to have another document with
the information going down in rows, so that I can print in portrait on one
sheet. How can I link these two documents?
Any help is appreciated.
Sue
 
N

Nicole

Hi Sue,

I would copy the entire table and paste it using "paste special" under the
EDIT menu. Select the "transpose" tick box and click OK.

I hope this helps.

Nicole
 
B

Bryan Hessey

Depending on how often you wanted to print, it might be easier to selec
the data (A1:BD15 etc) and Copy, then on a new sheet Paste Special
Values, Transpose.

(you may need to paste the formats (transpose) first.

otherwise you could put in A1

=OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)

or better still:

=IF(OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1)="","",OFFSET(Sheet1!$A$1,COLUMN()-1,ROW()-1))

and formula-drag that down 56 rows, then across for some columns

Hope this helps
 
Top