transpose and crosstab

Brad1

I trying to get this:

Acct Number	Type
111	A
111	B
222	H
222	I
222	J
222	K
333	M
444	A
444	X
444	Y
444	Z

To look like this:

Acct Number	Type1	Type2	Type3	Type4	Type5	Type6	Type7
111	A	B
222	H	I	J	K
333	M
444	A	X	Y	Z

Can it be done?  Any ideas?  Thanks.

tom_montpool

Definitely possible.

You'll need to add an additional field for the Crosstab tool to use as the field headings.

There are several ways to do it -- I've included one.

Solution.yxzp