Changing a Table layout

Hi,

off the top of my head I don't know how this can be achieved with functions, but you can "unpivot" the summary.

John Walkenbach explains how here:

http://j-walk.com/ss/excel/usertips/tip068.htm

HTH

Teylyn

Hi, Teylyn,

I'm familiar with Pivot-tables but if you'll look closer you'll see that in Johns examples each month recurrences 4 times.

In my example the number of recurrences differ for each client.

Any other idea [without an help-column].

Thanks.

WooooooooooooooooooooooooooooW !

You left me speechless.

Thanks.