Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose Function
I have a set of data
A1 Sat., Dec. 30, 2006 A2 Daily Temp A3 12-17-20-41-47-49 A4 12 A5 49 A6 Sun., Dec. 31, 2006 A7 Daily Temp A8 11-15-21-40-45-50 A9 11 A10 50 I name this Sheet "2006" Using the Transpose Function I set up =TRANSPOSE('2006'!A2:A5) On another sheet called "Results" in cell B2 How can I repeat this in B3 for data in Sheet 2006 A6 thru A10? This data continues to repeat in the same sequence (every 5 rows) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose function | Excel Discussion (Misc queries) | |||
Transpose Function | Excel Worksheet Functions | |||
Transpose Function? | Excel Worksheet Functions | |||
Transpose Function | Excel Worksheet Functions | |||
How do I use the Transpose Function | Excel Worksheet Functions |