transpose a table
 

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

transpose a table
 

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

"SuzyQ" wrote:

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

transpose a table
 

Depending on how often you wanted to print, it might be easier to select
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



SuzyQ Wrote:
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


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=480908