Thanks Jonathan for quickly responding and helping out.... 🙂 🙂

This exactly what I was looking for.

I will modify query and make it dynamic.

Thanks & Regards,

Loki

Thanks Jonathan for the query... 🙂

Output data is coming correctly but is it possible to get output data into corresponding pivoted columns.

I attached sample data in excel for better understanding...

Thanks Jonathan for your response.

I've attached sample output.