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) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose Function
Great function But it didn't seem to work. I got the logic of it. would it be better to use =ADDRESS((((ROW()-2)*5)+1),1,1,,"2006") and try to get the value another way? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose Function
by the way the tranpose function should be
=TRANSPOSE('2006'!A1:A5) and then =TRANSPOSE('2006'!A6:A10) too bad =TRANSPOSE(ADDRESS((((ROW()-2)*5)+1),1,1,,"2006"):ADDRESS((((ROW()-2)*5)+5),1)) won't work But I'd happy just getting the text for A3 & A8 into sequential rows on another sheet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transpose Function
Transpose in a single cell doesn't make much sense. Normally you would do a
multicell array formula. anyway, put this in B2 =OFFSET(Sheet1!$A$1,(ROW()-2)*5+COLUMN()-2,0,1,1) then drag fill over to column F then select B2:F2 and drag fill down -- Regards, Tom Ogilvy "wutzke" wrote in message oups.com... by the way the tranpose function should be =TRANSPOSE('2006'!A1:A5) and then =TRANSPOSE('2006'!A6:A10) too bad =TRANSPOSE(ADDRESS((((ROW()-2)*5)+1),1,1,,"2006"):ADDRESS((((ROW()-2)*5)+5),1)) won't work But I'd happy just getting the text for A3 & A8 into sequential rows on another sheet |
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 |