Transposing

  • Thread starter Thread starter scorer1
  • Start date Start date
S

scorer1

I have a worksheet that has student numbers in column 1 and then their
15 course requests across columns. I need to get that information into
a row format that lists their student course requests in rows, i.e.,
A1:A15 would contain their student number and B1:B15 would contain
their course requests. Any suggestions on how this can be done?
 
There's gotta be a "Copy" in there someplace ... No?,<g>

Select the data in a row.
Right click in the selection and choose "Copy".
Navigate to a section of the sheet where there's enough room for the data to
fill down the column.
Right click in the top cell of this section and choose "Paste Special".
Click on "Transpose", then <OK>, then <Esc>.
 
Back
Top