This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Try out this macro we use here at our company which transposes like Excel does. After that, I used a Multi-Field Formula tool to get rid of the underscores. Lastly, I used a Dynamic Rename tool to take the field names from the first row of data.
Hope this helps!
P.S. I believe @patrick_digan deserves credit for creating this awesome tool.