Editing File using awk/sed

Shell Programming and Scripting
1

Hello Awk Gurus,

Can anyone of you help me with the below problem. I have got a file having data in below format

pmFaultyTransportBlocks
-----------------------
9842993

pmFrmNoOfDiscRachFrames
-----------------------
NULL

pmNoRecRandomAccSuccess
-----------------------
30646380

I want to format this file into below format so that I can export it to excel using .csv

pmFaultyTransportBlocks,9842993
pmFrmNoOfDiscRachFrames,NULL
pmNoRecRandomAccSuccess,30646380

Thanks in Advance,
Mohammed

2 
awk '{ if( $0 !~ "^-" && length($0) ) { if ( set == 0 ) { printf "%s", $0; set = 1 } else { set = 0; printf ",%s\n", $0 } } }' filename
3 
sed -n "/^ *$/!{N;/\n---*$/s//,/;N;s/\n//p;}" file
4 
nawk 'BEGIN{FS=RS="";OFS=","}{print $1,$3}' myFile
5

Thanks vgersh99 your code is working really fine.
Thanks others for also helping me out
Thanks again!