copy cells from columns to rows

[Guest]

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110

 

[Guest]

hi.
copy you data then click where you want to paste it.
on the xl menu bar....
Edit>PasteSpecial>check transpose>click ok

regards
FSt1

 

[Guest]

That doesn't work. I had already tried that.

 

[Guest]

Insert in A1 and copy down

=OFFSET(Detail!$B$31,0,ROW(1:1)-1)


"Libby" skrev:

 

[Guest]

Libby,
with a bit of a step in between you can get this sorted.
First, highligt all cells that you want copied and use the "Replace"
functionality to change the "=" in the formula's to "qqq"
Then, copy the cells and using paste special transpose post them somewhere
as a column.
Select the pasted cells, and again using transpose change the "qqq" back to
"="
Now copy one column to the right - which gets you your references as desired.

To get it back into shape, go the other way around. Again, change = to qqq,
copy + transpose paste, change qqq to =

Bit of a roundabout way, but it works....

Good luck.