How to Transpose Excel data or Data Table?

Also this can be done using a VBA (Macro)
Thank you