View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wutzke wutzke is offline
external usenet poster
 
Posts: 34
Default 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)