How to transpose data imported into spotfire?



I am trying to parse data taken from an automated test sequence and my problem is that the data descriptor is in one column while the actual data is in another. For example, my descriptor in one column will be input voltage, and cell in the next column will be the data that I am trying to analyze. Is there any way that I can tranpose data from rows to columns in a smart way? Essentially, I would like a column that represents my input current, output voltage, etc.


(1) Answer