hi all..
i know this has been done to death.. and even by me... however hoping for a solution...
I have this table;
[TABLE="width: 261"]
<colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]Client[/TD]
[TD="width: 174, colspan: 2"]Staff Member[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]k[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]m[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]n[/TD]
[TD]Clint[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]o[/TD]
[TD]Steve[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]Max[/TD]
[/TR]
</tbody>[/TABLE]
what i'm hoping to output is a report to show which client belongs to who;
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {font-weight:700;}--></style>[TABLE="width: 435"]
<!--StartFragment--> <colgroup><col width="87" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 87"]Max[/TD]
[TD="class: xl63, width: 87"]Robert[/TD]
[TD="class: xl63, width: 87"]Charles[/TD]
[TD="class: xl63, width: 87"]Steve[/TD]
[TD="class: xl63, width: 87"]Clint[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]o[/TD]
[TD]n[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]f[/TD]
[TD]d[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]g[/TD]
[TD]e[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]j[/TD]
[TD]m[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]k[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
TIA
i know this has been done to death.. and even by me... however hoping for a solution...
I have this table;
[TABLE="width: 261"]
<colgroup><col width="87" span="3" style="width: 65pt;"></colgroup><tbody>[TR]
[TD="width: 87"]Client[/TD]
[TD="width: 174, colspan: 2"]Staff Member[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]f[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]g[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]j[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]k[/TD]
[TD]robert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]max[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]m[/TD]
[TD]charles[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]n[/TD]
[TD]Clint[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]o[/TD]
[TD]Steve[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]Max[/TD]
[/TR]
</tbody>[/TABLE]
what i'm hoping to output is a report to show which client belongs to who;
<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page {margin:.75in .7in .75in .7in; mso-header-margin:.3in; mso-footer-margin:.3in;}tr {mso-height-source:auto;}col {mso-width-source:auto;}br {mso-data-placement:same-cell;}td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignoreadding; color:black; font-size:12.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;}.xl63 {font-weight:700;}--></style>[TABLE="width: 435"]
<!--StartFragment--> <colgroup><col width="87" span="5" style="width:65pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 87"]Max[/TD]
[TD="class: xl63, width: 87"]Robert[/TD]
[TD="class: xl63, width: 87"]Charles[/TD]
[TD="class: xl63, width: 87"]Steve[/TD]
[TD="class: xl63, width: 87"]Clint[/TD]
[/TR]
[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]o[/TD]
[TD]n[/TD]
[/TR]
[TR]
[TD]h[/TD]
[TD]f[/TD]
[TD]d[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]i[/TD]
[TD]g[/TD]
[TD]e[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]l[/TD]
[TD]j[/TD]
[TD]m[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]p[/TD]
[TD]k[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]
TIA