Crosstab Issue with multiple columns

[tmcrouse]

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:

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>