Hi,

I try to learn how to write macros€¦ having problem with arranging a cycle.
I have a data that looks like that: Column A consist accounts #, rows B
through M the $ value, meaningfully attached to the cells B2, C2€¦M2.

A B C ...
M
06/01/31 06/02/28 March - Nov 06/12/31
1111111 26000 28000 30000 22000
2222222 11000 10500 10000 12500
3333333 13000 11500 20000 21000

I need to rearrange my data to look like that:
1111111^06/01/31^26000
1111111^06/02/28^28000
€¦
1111111^06/12/31^22000

The same has to be repeated 12 times for every next account until the end of
the sheet.

How would I do a macro for that?

Any help will be appreciated,
Thanks a lot,
Lu.