Dynamic Pivoting in Oracle

Preparing dummy data:

 

Pivoting: