Can someone please help me with my question attached? I tried using transpose tool but not getting my desired output.
Looks like you resolved your issue, but wanted to suggest another dynamic solution that should scale if you get more columns horizontally in your data set:
Issue Resolved.
@BrandonB I have similar solution but I did not use regex. Looking at your solution I changed mine. THANK YOU FOR YOUR HELP