Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACongratulation @messi007 !
My solution without Crosstab and Transpose.
Iteration Macro can increase data in horizontal direction(JOIN), in the most of case in vertical direction(UNION) though.
[Name]=ToDate(DateTimeAdd([#1],[Engine.IterationNumber],"Days"))
Done!
My solution