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
Solved! Go to 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.