Like this?
<b>Excel 2012</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Name</td><td style=";">Food 1</td><td style=";">Food 2</td><td style=";">Food 3</td><td style=";">Food 4</td><td style=";">Food 5</td><td style=";">Food 6</td><td style=";">Food 7</td><td style=";">Food 8</td><td style=";">Food 9</td><td style=";">Food 10</td><td style=";">Food 11</td><td style=";">Food 12</td><td style=";">Food 13</td><td style=";">Food 14</td><td style=";">Food 15</td><td style=";">Food 16</td><td style=";">Order</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Alan</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style=";">Food 2Food 5Food 9</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">Brian</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style=";">Food 1Food 4Food 8</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">Charlie</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style=";">Food 5Food 9Food 12Food 15</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">Dave</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style=";">Food 3Food 7Food 11Food 16</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">Eric</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style=";">Food 4Food 7Food 11Food 15</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">Frank</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style=";">Food 1Food 4Food 9Food 13</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">George</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style=";">Food 2Food 6Food 10Food 14</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">Hugh</td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;">X</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style=";">Food 1Food 3Food 8</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R2</th><td style="text-align:left">=IF(<font color="Blue">B2="X",B$1,""</font>)&IF(<font color="Blue">C2="X",C$1,""</font>)&IF(<font color="Blue">D2="X",D$1,""</font>)&IF(<font color="Blue">E2="X",E$1,""</font>)&IF(<font color="Blue">F2="X",F$1,""</font>)&IF(<font color="Blue">G2="X",G$1,""</font>)&IF(<font color="Blue">H2="X",H$1,""</font>)&IF(<font color="Blue">I2="X",I$1,""</font>)&IF(<font color="Blue">J2="X",J$1,""</font>)&IF(<font color="Blue">K2="X",K$1,""</font>)&IF(<font color="Blue">L2="X",L$1,""</font>)&IF(<font color="Blue">M2="X",M$1,""</font>)&IF(<font color="Blue">N2="X",N$1,""</font>)&IF(<font color="Blue">O2="X",O$1,""</font>)&IF(<font color="Blue">P2="X",P$1,""</font>)&IF(<font color="Blue">Q2="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R3</th><td style="text-align:left">=IF(<font color="Blue">B3="X",B$1,""</font>)&IF(<font color="Blue">C3="X",C$1,""</font>)&IF(<font color="Blue">D3="X",D$1,""</font>)&IF(<font color="Blue">E3="X",E$1,""</font>)&IF(<font color="Blue">F3="X",F$1,""</font>)&IF(<font color="Blue">G3="X",G$1,""</font>)&IF(<font color="Blue">H3="X",H$1,""</font>)&IF(<font color="Blue">I3="X",I$1,""</font>)&IF(<font color="Blue">J3="X",J$1,""</font>)&IF(<font color="Blue">K3="X",K$1,""</font>)&IF(<font color="Blue">L3="X",L$1,""</font>)&IF(<font color="Blue">M3="X",M$1,""</font>)&IF(<font color="Blue">N3="X",N$1,""</font>)&IF(<font color="Blue">O3="X",O$1,""</font>)&IF(<font color="Blue">P3="X",P$1,""</font>)&IF(<font color="Blue">Q3="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R4</th><td style="text-align:left">=IF(<font color="Blue">B4="X",B$1,""</font>)&IF(<font color="Blue">C4="X",C$1,""</font>)&IF(<font color="Blue">D4="X",D$1,""</font>)&IF(<font color="Blue">E4="X",E$1,""</font>)&IF(<font color="Blue">F4="X",F$1,""</font>)&IF(<font color="Blue">G4="X",G$1,""</font>)&IF(<font color="Blue">H4="X",H$1,""</font>)&IF(<font color="Blue">I4="X",I$1,""</font>)&IF(<font color="Blue">J4="X",J$1,""</font>)&IF(<font color="Blue">K4="X",K$1,""</font>)&IF(<font color="Blue">L4="X",L$1,""</font>)&IF(<font color="Blue">M4="X",M$1,""</font>)&IF(<font color="Blue">N4="X",N$1,""</font>)&IF(<font color="Blue">O4="X",O$1,""</font>)&IF(<font color="Blue">P4="X",P$1,""</font>)&IF(<font color="Blue">Q4="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R5</th><td style="text-align:left">=IF(<font color="Blue">B5="X",B$1,""</font>)&IF(<font color="Blue">C5="X",C$1,""</font>)&IF(<font color="Blue">D5="X",D$1,""</font>)&IF(<font color="Blue">E5="X",E$1,""</font>)&IF(<font color="Blue">F5="X",F$1,""</font>)&IF(<font color="Blue">G5="X",G$1,""</font>)&IF(<font color="Blue">H5="X",H$1,""</font>)&IF(<font color="Blue">I5="X",I$1,""</font>)&IF(<font color="Blue">J5="X",J$1,""</font>)&IF(<font color="Blue">K5="X",K$1,""</font>)&IF(<font color="Blue">L5="X",L$1,""</font>)&IF(<font color="Blue">M5="X",M$1,""</font>)&IF(<font color="Blue">N5="X",N$1,""</font>)&IF(<font color="Blue">O5="X",O$1,""</font>)&IF(<font color="Blue">P5="X",P$1,""</font>)&IF(<font color="Blue">Q5="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R6</th><td style="text-align:left">=IF(<font color="Blue">B6="X",B$1,""</font>)&IF(<font color="Blue">C6="X",C$1,""</font>)&IF(<font color="Blue">D6="X",D$1,""</font>)&IF(<font color="Blue">E6="X",E$1,""</font>)&IF(<font color="Blue">F6="X",F$1,""</font>)&IF(<font color="Blue">G6="X",G$1,""</font>)&IF(<font color="Blue">H6="X",H$1,""</font>)&IF(<font color="Blue">I6="X",I$1,""</font>)&IF(<font color="Blue">J6="X",J$1,""</font>)&IF(<font color="Blue">K6="X",K$1,""</font>)&IF(<font color="Blue">L6="X",L$1,""</font>)&IF(<font color="Blue">M6="X",M$1,""</font>)&IF(<font color="Blue">N6="X",N$1,""</font>)&IF(<font color="Blue">O6="X",O$1,""</font>)&IF(<font color="Blue">P6="X",P$1,""</font>)&IF(<font color="Blue">Q6="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R7</th><td style="text-align:left">=IF(<font color="Blue">B7="X",B$1,""</font>)&IF(<font color="Blue">C7="X",C$1,""</font>)&IF(<font color="Blue">D7="X",D$1,""</font>)&IF(<font color="Blue">E7="X",E$1,""</font>)&IF(<font color="Blue">F7="X",F$1,""</font>)&IF(<font color="Blue">G7="X",G$1,""</font>)&IF(<font color="Blue">H7="X",H$1,""</font>)&IF(<font color="Blue">I7="X",I$1,""</font>)&IF(<font color="Blue">J7="X",J$1,""</font>)&IF(<font color="Blue">K7="X",K$1,""</font>)&IF(<font color="Blue">L7="X",L$1,""</font>)&IF(<font color="Blue">M7="X",M$1,""</font>)&IF(<font color="Blue">N7="X",N$1,""</font>)&IF(<font color="Blue">O7="X",O$1,""</font>)&IF(<font color="Blue">P7="X",P$1,""</font>)&IF(<font color="Blue">Q7="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R8</th><td style="text-align:left">=IF(<font color="Blue">B8="X",B$1,""</font>)&IF(<font color="Blue">C8="X",C$1,""</font>)&IF(<font color="Blue">D8="X",D$1,""</font>)&IF(<font color="Blue">E8="X",E$1,""</font>)&IF(<font color="Blue">F8="X",F$1,""</font>)&IF(<font color="Blue">G8="X",G$1,""</font>)&IF(<font color="Blue">H8="X",H$1,""</font>)&IF(<font color="Blue">I8="X",I$1,""</font>)&IF(<font color="Blue">J8="X",J$1,""</font>)&IF(<font color="Blue">K8="X",K$1,""</font>)&IF(<font color="Blue">L8="X",L$1,""</font>)&IF(<font color="Blue">M8="X",M$1,""</font>)&IF(<font color="Blue">N8="X",N$1,""</font>)&IF(<font color="Blue">O8="X",O$1,""</font>)&IF(<font color="Blue">P8="X",P$1,""</font>)&IF(<font color="Blue">Q8="X",Q$1,""</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">R9</th><td style="text-align:left">=IF(<font color="Blue">B9="X",B$1,""</font>)&IF(<font color="Blue">C9="X",C$1,""</font>)&IF(<font color="Blue">D9="X",D$1,""</font>)&IF(<font color="Blue">E9="X",E$1,""</font>)&IF(<font color="Blue">F9="X",F$1,""</font>)&IF(<font color="Blue">G9="X",G$1,""</font>)&IF(<font color="Blue">H9="X",H$1,""</font>)&IF(<font color="Blue">I9="X",I$1,""</font>)&IF(<font color="Blue">J9="X",J$1,""</font>)&IF(<font color="Blue">K9="X",K$1,""</font>)&IF(<font color="Blue">L9="X",L$1,""</font>)&IF(<font color="Blue">M9="X",M$1,""</font>)&IF(<font color="Blue">N9="X",N$1,""</font>)&IF(<font color="Blue">O9="X",O$1,""</font>)&IF(<font color="Blue">P9="X",P$1,""</font>)&IF(<font color="Blue">Q9="X",Q$1,""</font>)</td></tr></tbody></table></td></tr></table><br />