danadeneve
New Member
- Joined
- Nov 2, 2011
- Messages
- 1
I'm trying to create a file which I can then use for Visio Org Chart creations. I have the source data which is a list of features the group is working on:
<TABLE style="WIDTH: 626pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=835><COLGROUP><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669; mso-outline-level: 1" width=73><COL style="WIDTH: 224pt; mso-width-source: userset; mso-width-alt: 10934; mso-outline-parent: collapsed" width=299><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059; mso-outline-level: 1" width=111><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><TBODY><TR style="HEIGHT: 63.75pt" height=85><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #0070c0; WIDTH: 55pt; HEIGHT: 63.75pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr id=td_post_1379060 class=xl71 height=85 width=73>Category</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 224pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl67 width=299>Feature </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl86 width=88>Marketing Rep</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=88>Director</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 83pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=111>Manager</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=88>Analyst</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl83 width=88>Architect</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>aaaaaaaaaaaaaaaaaaaaaaaaaaaa</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Thomas Stack</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Larrie Higgins</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Mark Digss</TD></TR>
<TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr id=td_post_1379060 class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>bbbbbbbbbbbbbbbbbbbbbbbbbbbbbb</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>ccccccccccccccccccccccccccccccccc</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>dddddddddddddddddddddddddddd</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>TBD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>eeeeeeeeeeeeeeeeeeeeeeeeeeee</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 44.25pt; mso-height-source: userset" height=59><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 44.25pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=59 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>fffffffffffffffffffffffffffffffffffffffffffffffffffffffff</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>ggggggggggggggggggggggggggggggggggggggg</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Larrie Higgins</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Jake Sook</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>lllllllllllllllllllllllllllllllllllllllllllllllllll</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Thomas Stack</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Mark Digss</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>mmmmmmmmmmmmmmmmmmmm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Tim Greggs</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>nnnnnnnnnnnnnnnnnnnnn</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>John Doe</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>oooooooooooooooooooooooooo</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>John Doe</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>qqqqqqqqqqqqqqqqqqqqqqqqq</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Jake Sook</TD></TR>
</TBODY></TABLE>
I need to end up with a format that looks like this:
<TABLE style="WIDTH: 969pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1290><COLGROUP><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 257pt; mso-width-source: userset; mso-width-alt: 12507" width=342><COL style="WIDTH: 371pt; mso-width-source: userset; mso-width-alt: 18066" width=494><COL style="WIDTH: 245pt; mso-width-source: userset; mso-width-alt: 11922" width=326><TBODY><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 96pt; HEIGHT: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=40 width=128>Resource Name</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 257pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=342>Catagory Working On (Single Category per line item)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 371pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=494>Features Working On (Concatenated List of All Assigned Features in Category)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 245pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=326>Role (Concatenated list of Roles, or Primary Role)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 height=20>example:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 120pt" height=160><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 120pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=160>Chris Jones</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Cat 1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 371pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=494>ggggggggggggggggggggggggggggggggggggggg, hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh, iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii, jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj, kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk, mmmmmmmmmmmmmmmmmmmm, jkjkjkjkjkjkjkjkjkjkjkjkjkjk, 777777777, 8888888888888, 16161616161, 1919191991, 2020202020202, 2323232323232320, 3737373, lllllllllllllllllllllllllllllllllllllllllllllllllll, hihihihihihihihihihihihihih, 1414141414141410</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Manager, Analyst</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=20>Chris Jones</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Cat 2 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>ccccccccccccccccccccccccccccccccc, qqqqqqqqqqqqqqqqqqqqqqqqq</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Manager </TD></TR></TBODY></TABLE>
Issue is that the "Resource Name" can show up in any of four different columns in the Source data (Marketing Rep, Director, Manager, Analyst, Architect). The other issue is that I'm not sure how to do a VLookup that can concat multiple results so I can see a list of all features they are assigned for a given category.
I will create an org chart for each Category which is why I need a seperate line for each category, then each resource.
Please help! I've tried so many days and many internet searches and am not there.
<TABLE style="WIDTH: 626pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=835><COLGROUP><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669; mso-outline-level: 1" width=73><COL style="WIDTH: 224pt; mso-width-source: userset; mso-width-alt: 10934; mso-outline-parent: collapsed" width=299><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 4059; mso-outline-level: 1" width=111><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218; mso-outline-level: 1" width=88><TBODY><TR style="HEIGHT: 63.75pt" height=85><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: #0070c0; WIDTH: 55pt; HEIGHT: 63.75pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr id=td_post_1379060 class=xl71 height=85 width=73>Category</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 224pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl67 width=299>Feature </TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl86 width=88>Marketing Rep</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=88>Director</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 83pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=111>Manager</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl79 width=88>Analyst</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: #0070c0; WIDTH: 66pt; BORDER-TOP: black 1pt solid; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl83 width=88>Architect</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>aaaaaaaaaaaaaaaaaaaaaaaaaaaa</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Thomas Stack</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Larrie Higgins</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Mark Digss</TD></TR>
<TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr id=td_post_1379060 class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>bbbbbbbbbbbbbbbbbbbbbbbbbbbbbb</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>ccccccccccccccccccccccccccccccccc</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>dddddddddddddddddddddddddddd</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>TBD</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>eeeeeeeeeeeeeeeeeeeeeeeeeeee</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 44.25pt; mso-height-source: userset" height=59><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 44.25pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=59 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>fffffffffffffffffffffffffffffffffffffffffffffffffffffffff</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Jane Branch</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Henry Rood, Ralph Wires</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>ggggggggggggggggggggggggggggggggggggggg</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Larrie Higgins</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Jake Sook</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>lllllllllllllllllllllllllllllllllllllllllllllllllll</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Thomas Stack</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Mark Digss</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>mmmmmmmmmmmmmmmmmmmm</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Tim Greggs</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl69 width=299>nnnnnnnnnnnnnnnnnnnnn</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>John Doe</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 3</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>oooooooooooooooooooooooooo</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>John Doe</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Mark Diggs</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Rick Hunts</TD></TR><TR style="HEIGHT: 25.5pt" height=34><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 55pt; HEIGHT: 25.5pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl72 height=34 width=73>Cat 2</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: transparent; WIDTH: 224pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl68 width=299>qqqqqqqqqqqqqqqqqqqqqqqqq</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 1pt solid; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl85 width=88>Marketing Resource 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>Director 1</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 83pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=111>Chris Jones</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" dir=ltr class=xl80 width=88>N/A</TD><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black; BACKGROUND-COLOR: white; WIDTH: 66pt; BORDER-TOP: black; BORDER-RIGHT: black 1pt solid" dir=ltr class=xl84 width=88>Jake Sook</TD></TR>
</TBODY></TABLE>
I need to end up with a format that looks like this:
<TABLE style="WIDTH: 969pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1290><COLGROUP><COL style="WIDTH: 96pt; mso-width-source: userset; mso-width-alt: 4681" width=128><COL style="WIDTH: 257pt; mso-width-source: userset; mso-width-alt: 12507" width=342><COL style="WIDTH: 371pt; mso-width-source: userset; mso-width-alt: 18066" width=494><COL style="WIDTH: 245pt; mso-width-source: userset; mso-width-alt: 11922" width=326><TBODY><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 96pt; HEIGHT: 30pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 height=40 width=128>Resource Name</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 257pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=342>Catagory Working On (Single Category per line item)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 371pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=494>Features Working On (Concatenated List of All Assigned Features in Category)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 245pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl71 width=326>Role (Concatenated list of Roles, or Primary Role)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl70 height=20>example:</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68></TD></TR><TR style="HEIGHT: 120pt" height=160><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 120pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=160>Chris Jones</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Cat 1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 371pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl69 width=494>ggggggggggggggggggggggggggggggggggggggg, hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh, iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii, jjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjjj, kkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk, mmmmmmmmmmmmmmmmmmmm, jkjkjkjkjkjkjkjkjkjkjkjkjkjk, 777777777, 8888888888888, 16161616161, 1919191991, 2020202020202, 2323232323232320, 3737373, lllllllllllllllllllllllllllllllllllllllllllllllllll, hihihihihihihihihihihihihih, 1414141414141410</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Manager, Analyst</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68 height=20>Chris Jones</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Cat 2 </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>ccccccccccccccccccccccccccccccccc, qqqqqqqqqqqqqqqqqqqqqqqqq</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl68>Manager </TD></TR></TBODY></TABLE>
Issue is that the "Resource Name" can show up in any of four different columns in the Source data (Marketing Rep, Director, Manager, Analyst, Architect). The other issue is that I'm not sure how to do a VLookup that can concat multiple results so I can see a list of all features they are assigned for a given category.
I will create an org chart for each Category which is why I need a seperate line for each category, then each resource.
Please help! I've tried so many days and many internet searches and am not there.
