test1

[#1]

ss

[petter]

This is one way of doing it:

[#3]

What about Date column petter

[petter]

yes I overlooked/forgot about that - but here is a slightly modified script to cater for that. Had to split the preceding load and make it into a resident load instead to get hold of the dates:

[#5]

For two days data it is good but we are getting monthly data.. then I need to change for daily?

Is there any solution Petter?

[petter]

You should have mentioned this in the first place - because then I would have suggested a different more dynamic approach. I will not be able to suggest anything until later today ... I  actually have a solution made previously I could provide you with later this evening...

[#7]

K & Thank u very much for your valuable time Petter.......

[petter · Accepted solution]

This is a dynamic version of it that will take any number of days and transform it into rows...

[#9]

I Have some doubts Petter....

Please send me your mailid