Copy/Move Rows to Columns

  • Thread starter Thread starter Tom L.
  • Start date Start date
T

Tom L.

Help please. Can anyone tell me if you can select data
organized in a 'row' and copy or move to a 'column'. For
example, a string of data in cells a1..d1 copied or moved
to e1..e4. Thanks - Tom
 
Hi Tom!

Save your data!!

And then play around with Copy > Paste Special > Transpose > OK

There's also an array entered TRANSPOSE function that might be useful.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top