How to transpose data elements in awk

Shell Programming and Scripting
1

Hi,

I have an input data file :-
Test4599,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,Rain
Test90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,1,0,Not Rain
etc....

I wanted to transpose these data to:-

Test4599 Test90
0 0
0 0
.. ...
In other words, I wanted to transpose elements from vertical to horizontal.
Any idea on how to do that using Awk?

Please advise.

Thanks.

2

The "similar threads" box near the bottom of the page looks vaguely promising.

3

awk -F, 'BEGIN {max_i=0} { \
for(i=1;i<=NF;i++) {text_arr[NR SUBSEP i]=$NF} \
if ( NF > max_i ) {max_i = NF}} \
END { for(i=1;i<=max_i;i++) { for(j=1;j<=NR;j++)\
printf text_arr[j SUBSEP i];print}}}' file.txt

I did not tested it, but should be very close to the final solution.
Luck