help formatting

Shell Programming and Scripting
1

I need to format a txt file and convert it in CSV.

Any "future" column is separated by a newline.

FROM:

XS1
1.43294
0.0

XS2
1.21824
0.0

TO:

XS1,XS2
1.43294,1.21824
0.0,0.0

Thanks in advance,

Alfredo

2

If you want 2 columns :

sed '/^[[:blank:]]*$/d' yourfile | pr -2 -t -s","

---------- Post updated at 06:51 PM ---------- Previous update was at 06:49 PM ----------

$ cat tst2
XS1
1.43294
0.0

XS2
1.21824
0.0

$ sed '/^[[:blank:]]*$/d' tst2 | pr -2 -t -s","
XS1,XS2
1.43294,1.21824
0.0,0.0
$
3 
 echo 'XS1
1.43294
0.0
XS2
1.21824
0.0
XS1
1.43294
0.0
XS2
1.21824
0.0' |awk '{a[NR%4]=length(a[NR%4])?a[NR%4]","$0:$0}END{for(i=1;i<=3;i++) print a}'
XS1,XS2,XS1,XS2
1.43294,1.21824,1.43294,1.21824
0.0,0.0,0.0,0.0