Structured and tidy data is great to work with, because on the command line you can reliably convert one structure into another. This post demonstrates how you can turn comma-separated lists into a presence/absence pivot table.
Source: LXer – Converting a list to a presence/absence table