Pivotting/transposing columns to rows

Thanks harishgg1, you have reminded me that I did it like this before. A bit long but effective. Thank you!