Help for Charting of weekly data to daily data

[Access Beginner]

Hi guys,

I have a data set ( screen shot below. 1st time using Jeanie HTML, so I hope this works).

I have only import two weeks of data, but this data will be for at least 12 months.

Data as extracted

Excel Workbook
	C	D	E	F	G	H	I	J
1	Data as extracted
2		Sat	Sun	Mon	Tue	Wed	Thu	Fri
3	29/04/2011	738	289	25	343	536	582	938
4	22/04/2011	653	816	173	507	367	942	154
Sheet1

Desired Results

Excel Workbook
	C	D
6	Deisred Result
7	Friday, 29 April 2011	938
8	Thursday, 28 April 2011	582
9	Wednesday, 27 April 2011	536
10	Tuesday, 26 April 2011	343
11	Monday, 25 April 2011	25
12	Sunday, 24 April 2011	289
13	Saturday, 23 April 2011	738
14	Friday, 22 April 2011	154
15	Thursday, 21 April 2011	942
16	Wednesday, 20 April 2011	367
17	Tuesday, 19 April 2011	507
18	Monday, 18 April 2011	173
19	Sunday, 17 April 2011	816
20	Saturday, 16 April 2011	653
Sheet1

The data as extracted is good for weekly analysis, but I do not know how to convert it two daily data, except manually. Not a big deal for a small data set, but I have 12 months of data in this format.

Hoping someone can be of assistance.

 

[martindwilson]

in l3
=MIN(C:C)-6
in l4
=IF(ROW(C2)>COUNT(C:C)*7,"",ROUND(L3+1,0)) dragged down
in m3
=INDEX(D:J,MATCH(L3,C:C,-1),IF(MOD(ROW(C1),7)=0,7,MOD(ROW(C1),7))) dragged down