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,R ain
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,N ot 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.

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

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