One small comment about language: In English, you would not say "the next structure", but rather, "the following structure".
>Hi guys!
>
>We receive from CEO office a table with the next structure:
>
>
>StoreID | Month | Year | Account | Amount |
>----------------------------------------------------
>Chr 4 | Chr 2 | Chr 4 | Chr 11 | Num 12 0 |
>
>
>We have all the information for 2006 and the data till July for 2007. With this, my boss ask me to build something like this:
>
>
>StoreID | Account | Jan 06 | Feb 06 | Mar 06 | ETC.
>----------------------------------------------------
>Chr 4 | Chr 11 | Amount | Amount | Amount | Amount|
>
>
>Is there any easy way to convert this? I´ll have to do it every month, and it would be great to have just a table like this.
>
>TIA!
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)