DataMystic

I have a csv file and am wondering if TextPipe can TRANSPOSE it.

Basically, my text comes out as

Hour,1,2,3,4,5
Temp,60,61,62,63

and i want it to be transposed to a table format

Hour Temp
1 60
2 61
3 62
4 63

Here is an actual dataset

Hour,11,12,13,14,15,16,17,18,19,20,21,22,23,0,1,2,3,4,5,6,7 ...