awk 'FNR==1' File*.csv |tr "," "\n" |sort -u > title.txt

"ColA"
"ColB"
"ColC"
"ColD"
"ColE"
"ColF"
"ColG"

mkdir Super

awk -F , '
NR==FNR {title[FNR]=$1;b[$1]=FNR;n=FNR;next} 
FNR==1 {   
           for (i=1;i<=n;i++) 
              { 
                  printf title[i] FS > "Super/" FILENAME
                  sign[i]=0
               }
           printf "\n" > "Super/" FILENAME
           for (i=1;i<=NF;i++)
              sign[b[$i]]=1
           next
       }
{    
     split($0,x,",")
     for (i=1;i<=n;i++)
         { 
           printf (sign[i]=="1")? x[++j] FS:"\"\"" FS > "Super/" FILENAME
         }
     printf "\n" > "Super/" FILENAME
     j=0
}
' title.txt *.csv

$ cat Super/File2.csv
"ColA","ColB","ColC","ColD","ColE","ColF","ColG",
"","","","Dat204","Dat205","Dat206","Dat207",
"","","","Dat214","Dat215","Dat216","Dat217",

for file in Super/File*.csv
do
  sed 's/,$//' $file > tmp
  mv tmp $file
done

for file in Super/File*.csv
do
  sed -i 's/,$//' $file > tmp
done

awk 'NR==1||FNR>1' Super/*.csv