Transpose Crosstab

[Brad1]

How can I go from this:

Store_Num	Ntwk_Nme
1	Ntwk_A
1	Ntwk_B
1	Ntwk_C
2	Ntwk_B
2	Ntwk_D

to this:

Store_Num	Ntwk_A	Ntwk_B	Ntwk_C	Ntwk_D
1	X	X	X
2		X		X

Thanks in advance for any help.

[Bob_Blackey · Accepted solution]

Hi,

The attached workflow does it.

Just add a new field "Check" with a value of "X"

and then the Cross Tab

Cheers,
Bob

[Brad1]

I like yours better than mine.  thx.