Hi. Me and my collegues have encountered this problem many times but we still haven't found an adequate solution. Please help! This is actually exactly what the Excel command Transpose does (when pasting copied data).
I want this data
to be transposed to this data
And if there a more ELEMENTS (after Zn) it should dynamically be included... We have looked at all the transpose posts here but we haven't found a good answer. ELEMENT, As, Ba and so on should be turned into attribute names for further use in the script.
Any help will be gratefully accepted.
Peter et al