Crosstab query where column value is text from a field in the row

[jpkeller55]

I am sure this is doable, but can't figure it out. I am trying to write a crosstab query which will take data from a table in this format:

Name	InsurSeq	InsurName
Bill	1	BCBS-IL
Bill	2	Cigna
Bill	3	Medicaid
Dave	1	Aetna
Dave	2	Medicare
Sue	1	Cigna
Sue	2	Aetna
Sue	3	Medicare

And put the data in this format:

Name	1	2	3
Bill	BCBS-IL	Cigna	Medicaid
Dave	Aetna	Medicare
Sue	Cigna	Aetna	Medicare

Any help would be greatly appreciated. Thanks

[jpkeller55]

Figured it out on my own:

TRANSFORM First(Table1.InsurName) AS FirstOfInsurName
SELECT Table1.Name
FROM Table1
GROUP BY Table1.Name
PIVOT Table1.InsurSeq;