I thought I had posted this question yesterday but don't think I hit the submit button. I am having issues with a crosstab using multple columns and retaining all the other attached data. I have a large number of people that have distinct rows but there are lots of peope in my file.
Example of what I have and need:
<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1792" span=2 width=50><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2019" width=57><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2190" width=62><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2958" width=83><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2417" width=68><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 824" width=23><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1280" width=36><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 995" width=28><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 938" span=2 width=26><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1109" width=31><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 938" width=26><TBODY>
</TBODY>
<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1792" span=2 width=50><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2019" width=57><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2190" width=62><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2958" width=83><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2417" width=68><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 824" width=23><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1280" width=36><TBODY>
</TBODY>
Example of what I have and need:
DATA HAVE | ||||||||||||||||
MID | CONTRACT | FNAME | LNAME | GENDER | DOB | ADDRESS1 | ADDRESS2 | CITY | ST | ZIP | tb1 | tb2 | tb3 | tb4 | tb5 | tb6 |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | eye | a1c | bcs | col | awc | flu |
<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1792" span=2 width=50><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2019" width=57><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2190" width=62><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2958" width=83><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2417" width=68><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 824" width=23><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1280" width=36><COL style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 995" width=28><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 938" span=2 width=26><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 1109" width=31><COL style="WIDTH: 20pt; mso-width-source: userset; mso-width-alt: 938" width=26><TBODY>
</TBODY>
DATA NEED | |||||||||||
MID | CONTRACT | FNAME | LNAME | GENDER | DOB | ADDRESS1 | ADDRESS2 | CITY | ST | ZIP | TB |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | EYE |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | A1C |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | BCS |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | COL |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | AWC |
1a1a1a01 | H0564-056 | wanda | miller | F | 1/1/2015 | 111 baker str | #4 | BAKERSFIELD | CA | 93305 | FLU |
<COLGROUP><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 2673" width=75><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1792" span=2 width=50><COL style="WIDTH: 43pt; mso-width-source: userset; mso-width-alt: 2019" width=57><COL style="WIDTH: 46pt; mso-width-source: userset; mso-width-alt: 2190" width=62><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2958" width=83><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2417" width=68><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3015" width=85><COL style="WIDTH: 17pt; mso-width-source: userset; mso-width-alt: 824" width=23><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=43><COL style="WIDTH: 27pt; mso-width-source: userset; mso-width-alt: 1280" width=36><TBODY>
</TBODY>