Shell Programming and Scripting

awk '
NR==FNR {col[NR]=$0; cc=NR; cols[NR]=length($0); a[$0]=$0; next}
NR!=FNR && ! c++ {
   printf ("%-12s|%-12s", "VAN-ID", "VLAN-NAME");
   for (i=1 ; i<=NR; i++) {
      colw[i]=length(col[i]);
      printf ("%s%s", ((i<NR) ? "|" : "\n"), col[i]);
   }
}
{
   sub("^[ \"]*", "", $2);
   sub("[ \"]*$", "", $2);
   if ($2) {
      for (i in aa) delete aa[i];
      for (i in dd) delete dd[i];
      for (i=3; i<=NF; i++) if ($i in a) {aa[$i]=" * "}
      for (i=1; i<=cc; i++) {if (col[i] in aa) {dd[i]=" * "}}
      printf ("%12s|%-12s|"), $1, $2;
      for (i=1; i<=cc; i++) printf("%*s%s", cols[i], dd[i], ((i<cc) ? "|" : "\n"));
   }
}
' file-1 FS=, file-2

awk -F"," -v OFS="|" 'NR==FNR { C[$1] ; next } # Save list of ports

{
        ID[$1]  # Save list of IDs
        D[$1,"NAME"]=$2
        for(N=3; N<=NF; N++)    D[$1,$N]
}

END {   for(X in ID) # Print everything
        {
                $0=""; $1=X ; $2=D[X,"NAME"];
                L=3;
                for(V in C)
                {
                        if ((X,V) in D) $L="*";
                        L++
                }
                print;
        }
}' file-1 file-2

awk -F, '
FNR == NR       {PNR[$1]  = MAXP = NR
                 PORt[NR] = $1
                 next
                }
FNR == 1        {printf "VLAN-ID |  VLAN-NAME "
                 for (i=1; i<=MAXP; i++) printf "|%s", PORt[i]
                 printf RS
                }
                {gsub (/"/, _, $2)
                 printf "%7d |%11s ", $1, $2
                 split (sprintf ("%*s", MAXP, " "), T, _)
                 for (i=3; i<=NF; i++) T[PNR[$i]] = "*"
                 for (i=1; i<=MAXP; i++) printf "| %c ", T[i]
                 printf RS
                }

' file1 file2
VLAN-ID |  VLAN-NAME |1/1|1/2|1/3|1/4|1/5|1/6|1/7|1/8
      1 |  vlan-wifi | * |   |   |   |   |   | * | * 
      2 | vlan-admin |   |   | * |   | * | * |   |   
      3 |            |   |   | * |   |   |   |   |