| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing from Rows to Columns
On sheet one I track attendance. In Column A are names. In Columns D-AH (are the dates 1-31). Row 1 Date header; Row 2, Day text (as 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 on another sheet, but in a single column so I can print a report on a single sheet of paper. Is there a way to do it quickly without referencing each individual cell manually? -- RayH ------------------------------------------------------------------------ RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647 View this thread: http://www.excelforum.com/showthread...hreadid=564044 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing from Rows to Columns
Hi!
Select the range D3:AH3 Goto EditCopy Navigate to the other sheet and select the first cell where you want the data to appear. Goto EditPaste SpecialTransposeOK Biff "RayH" wrote in message ... On sheet one I track attendance. In Column A are names. In Columns D-AH (are the dates 1-31). Row 1 Date header; Row 2, Day text (as 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 on another sheet, but in a single column so I can print a report on a single sheet of paper. Is there a way to do it quickly without referencing each individual cell manually? -- RayH ------------------------------------------------------------------------ RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647 View this thread: http://www.excelforum.com/showthread...hreadid=564044 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing from Rows to Columns
Thank you. -- RayH ------------------------------------------------------------------------ RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647 View this thread: http://www.excelforum.com/showthread...hreadid=564044 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Changing from Rows to Columns
You're welcome!
Biff "RayH" wrote in message ... Thank you. -- RayH ------------------------------------------------------------------------ RayH's Profile: http://www.excelforum.com/member.php...o&userid=36647 View this thread: http://www.excelforum.com/showthread...hreadid=564044 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How to reverse order of rows and columns | Excel Discussion (Misc queries) | |||
| Changing Columns to Rows Question | Excel Discussion (Misc queries) | |||
| hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
