View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Moohwan Moohwan is offline
external usenet poster
 
Posts: 3
Default to create rolling windows from a column

Please help me out.
For example, suppose I have a series below.
2
3
4
5
6
7
If I want to have 3-observation rolling windows, how could I accomplish the
task?
The outcome I want is as follws.
2 3 4 5
3 4 5 6
4 5 6 7

thanks in advance