Copying Rows to Cokumns?

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Is there a way to copy a row of data to a column of data.

We have information that is recorded daily in a series of rows. Sheets are
arrainged so that information for days 1 - 31 are in columns, and the
information for each category is in its own row.

Now, of course, we would like to take some items and separate them into
their own sheets but arrainge the data vertically so that each catagory has
it's own column.

Help wasn't much help. It wanted to send me to pivot tables.

Is there an easy way to do this? So far it has been cell by cell, which is
really time consuming.

Thanks!

-alex

to email: (amb AT comcast DOT net)
 
From the menu, look at Edit | Paste Special, in the Paste Special dialog.
check the Transpose option...
 
Back
Top