Well, for future reference, this kind of tabular structure makes reporting
and summarizing terribly hard. You are better off with a columnar approach

Actor Action
Teddy Nailbiting
Stilts Crying
Stilts Nailbiting
etc.


You can create a pivot table off that structure and end up with EITHER of
your two grids.

If your source range has no formulas in it, you can select the whole thing &
copy it, then go to you destination workbook and do a Paste
Special-Transpose. If you have formulas and don't care about them, i.e.,
all you need is the value, you can do a Paste Special-Values and Transpose

Does that work?



"aleeherself" wrote:

No, Duke, it is not as simple as that multiple 416 by 15 and that would be
more like it. It is only 15 on one axis but the other one is extensive.
Unfortunately the designer of the original worksheet knows very little about
doing spreadsheets and the way that he did it was just tortuous to read. To
simplify it though, here is a mock-up of the source document:

Nailbiting Crying Yelling
Stealing
Bowser X X X
0
Randy X X X
0
Stilts X X 0 0
Teddy X 0 X
X

And we want to change it to read:
Bowser Randy Stilts Teddy
Nailbiting X X X X
Crying X X X
0
Yelling X X 0 X
Stealing 0 0 0 X

How do we transfer this info? and I do SO appreciate your help!!!


"Duke Carey" wrote:

You cannot combine a Paste Link action with a Transpose action.
Unfortunately, for only 15 cells the most expedient way is to simply
copy/paste link one cell at a time.

If this is a bigger job, or something that has to be done regularly, post
back. There are ways to deal with it, though not without a little effort to
set it up.

"aleeherself" wrote:

Hello! I am trying to copy 15 cells in a row in one document to 15 cells in
a column in another document. The past link function seems to work until I
check the data and find that the data does not transfer accurately. Does
anyone know what the solution is to this problem? I get the information to
paste vertically along the column by highlighting the cells that I want it to
copy into before I click Paste Link, but still the information is totally
wrong!