It got me the output in the desired format ....

Can you please explain me the concept of "pivot" and the logic behind this query ......

I am just aware of the...

This did help. Thank you ....

I have come across a good question. I am attaching a word file describing the problem.

I have tried solving the problem but I did not...

Hello Marcin,

I have attached a document that explains my example.

Thanks,

Shashi