dataset

[Carolyne]

MEMBER ID	Test Done
123	NT
123	BP
231	EE
231	NP
145	BP
155

To this:

MEMBER ID	NT	EE	BP
123	Y	N	Y
231	N	Y	N
145	N	N	Y
155	N	N	N

Thanks

[kelsey_kincaid · Accepted solution]

Hi @Carolyne -

You could cross-tab your data, then use a Multi-Field formula to convert your data to Y or N and then Select to remove unwanted columns. Example is attached.