Hi pual ,

i got suceeded with pivot and unpivot.But i First transpose this to unpivot then pivot the table.I take two steps for this.

But you have done this in single steps.thanks for reply.

your code is pretty ,simple and excellent.