Referring to the below post can is the feature of dynamic sub query facility available now ?
For Example :
Actual Data Is


But I want output like this.


Can you please advice
Reference Post : https://forums.oracle.com/ords/apexds/post/converting-rows-into-columns-in-oracle-11g-2228