M,

If your original data has any more rows than that shown in the example,
then I don't believe Excel has enough rows to display the requested lay out.
Even if it would fit, someone would have to pay me write the code.
But there are a lot smarter people than me contributing here who
may some ideas.

Jim Cone
San Francisco, USA


"MC82" wrote in message
...

Hi Jim, Thanks for the input. I did as you suggested, one of the
criterias that I left out is that the columns need to stay in the same
order, what changes is the value of the column. Not sure if that makes
sense.--
MC82