Changing from Rows to Columns

R

RayH

On sheet one I track attendance. In Column A are names. In Column
D-AH (are the dates 1-31). Row 1 Date header; Row 2, Day text (a
determined by row 1); Row 3 the total attendance of the day.

So D3:AH3 have the totals. I want to put the information in Row 3 o
another sheet, but in a single column so I can print a report on
single sheet of paper. Is there a way to do it quickly withou
referencing each individual cell manually
 
B

Biff

Hi!

Select the range D3:AH3
Goto Edit>Copy
Navigate to the other sheet and select the first cell where you want the
data to appear.
Goto Edit>Paste Special>Transpose>OK

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy cells from columns to rows 4
Searching worksheet and exporting name to other sheet 1
Excel Is this possible?? 3
Excel Help to copy information from one row at a time to another sheet 1
rows and columns on worksheet 1
Vlookup or Hlookup 7
Excel EXCEL - using a date dependant formula to hide rows 3
Formula from consecutive rows to alternate rows? 2

Top