Converting Daily Data into Weekly

[Manan]

Hi All ,

I have below sample data. Can you please let me know how to convert this daily data in Weekly. Below is sample data i have 1000's of rows to process.
Date Close
7-Oct-09 789
8-Oct-09 790.4
9-Oct-09 781
12-Oct-09 775
14-Oct-09 803.55
15-Oct-09 791.15
16-Oct-09 802.9
17-Oct-09 795.5
20-Oct-09 840
21-Oct-09 836
22-Oct-09 827
23-Oct-09 856.8
26-Oct-09 855.7
27-Oct-09 805.3
28-Oct-09 793.55
29-Oct-09 743.8
30-Oct-09 730.7
3-Nov-09 698
4-Nov-09 770
5-Nov-09 791
6-Nov-09 811
9-Nov-09 903.5
10-Nov-09 880
11-Nov-09 879
12-Nov-09 874
13-Nov-09 873.1
16-Nov-09 875.65
17-Nov-09 878.55
18-Nov-09 885.55
19-Nov-09 851.5
20-Nov-09 858
23-Nov-09 843
24-Nov-09 845
25-Nov-09 857
26-Nov-09 838.2
27-Nov-09 853.8
30-Nov-09 855
1-Dec-09 869
2-Dec-09 853
3-Dec-09 850.45
4-Dec-09 849.75
7-Dec-09 836.9
8-Dec-09 852
9-Dec-09 827.2
10-Dec-09 824.2
11-Dec-09 810.05
14-Dec-09 792.05
15-Dec-09 787.85
16-Dec-09 791
17-Dec-09 787.3
18-Dec-09 770
21-Dec-09 765
22-Dec-09 773.4
23-Dec-09 791.1
24-Dec-09 789.2
29-Dec-09 806.7
30-Dec-09 801.25
31-Dec-09 820
4-Jan-10 819
5-Jan-10 816
6-Jan-10 810.55
7-Jan-10 829.9
8-Jan-10 833.7
11-Jan-10 837.35
12-Jan-10 825.5
13-Jan-10 832
14-Jan-10 849
15-Jan-10 840
18-Jan-10 839
19-Jan-10 833
20-Jan-10 812.9
21-Jan-10 819.9
22-Jan-10 793.1
25-Jan-10 791.9
27-Jan-10 734.75
28-Jan-10 735
29-Jan-10 770
1-Feb-10 775
2-Feb-10 770

 

[Asheesh]

Hi Manan - Does the attached help

 

[Hui]

I used Asheesh's data but threw it through a Pivot table
Then Grouped the rows by 7 Days


See attached file:

To start at a set date you need to add a record with zero value at the first date you want the summary to start at.

 

[Asheesh]

@Hui - I somehow forgot the pivot option....thanks for reminding & much better option...

 

[Manan]

@Hui - I somehow forgot the pivot option....thanks for reminding & much better option...

Thanks a lot ashish , your solution is wonderful and suits my requirement.

 

[Manan]

I used Asheesh's data but threw it through a Pivot table
Then Grouped the rows by 7 Days
View attachment 17365

See attached file:

To start at a set date you need to add a record with zero value at the first date you want the summary to start at.

Thanks Master, A good solution and definitely a new learning in pivots. Thanks again.