Hello guys I have an interesting query. I have a dataset with certain columns named as start date, end date, type, item, For instance the toy data set looks as: start _date end_date type category 1/1/2011 5/1/2011 A 1945 16/1/2011 30/1/2011 B 1945 2/2/2011 3/2/2011 c 1945 4/2/2011 5/2/2011 A 1945 16/1/2011 30/1/2011 B 1945 17/1/2011 25/1/2011 B 1945 Now basically this information I have for entire year up to December. Now I want to extract the information from the data set in vertical manner so that my output dataset looks like the following: date Type 1/1/2011 A 1945 2/1/2011 A 1945 3/1/2011 A 1945 4/1/2011 A 1945 5/1/2011 A 1945 so on 16/1/2011 B 1945 17/1/2011 B 1945 18/1/2011 B 1945 19/1/2011 B 1945 so on up to 30/1/2011 B 1945 2/2/2011 C 3/2/2011 C 4/2/2011 A 5/2/2011 A So essentially the tasks are two fold: Firstly the information given in range(start date :end date) should appear row wise with each date corresponding to one row. Secondly, corresponding to input data set, I want to get the value of type on that particular day. For instance if for the range 16/1/2011-30/1/2011 type has value B then in the output data set, each row corresponding to one single date should as entry B I want to automate the above process as the input data set is enormous, so basically if one can help me with any code/macro which would automatically accomplish the above task, that would be highly appreciated. Thanks Ravinder
... View more