Expand span days with values

[#1]

How do I expand a list of span days with values?

For example

11/01/2011, 1

11/05/2011, 5

11/12/2011, 10

11/20/2011, 20

11/30/2011, 3

should expand into these values

11/01/2011, 1

11/02/2011, 1

11/03/2011, 1

11/04/2011, 1

11/05/2011, 5

11/06/2011, 5

11/07/2011, 5

11/08/2011, 5

11/09/2011, 5

11/10/2011, 5

11/11/2011, 5

11/12/2011, 10

11/13/2011, 10

11/14/2011, 10

11/15/2011, 10

11/16/2011, 10

11/17/2011, 10

11/18/2011, 10

11/19/2011, 10

11/20/2011, 20

11/21/2011, 20

11/22/2011, 20

11/23/2011, 20

11/24/2011, 20

11/25/2011, 20

11/26/2011, 20

11/27/2011, 20

11/28/2011, 20

11/29/2011, 20

11/30/2011, 3

thanks,

James

[#2]

This question was picked and answered in a separate thread

http://community.qlik.com/message/173239#173239

thanks,

James