I have an issue with comma-separated values analysis and pivot tables in Google Spreadsheets. What if I have the following dataset:
Facebook, Github Developer No answer Developer Github, MSDN Developer Facebook, Github Developer Artstation Designer Beahnca, Artstation Designer 3DTotal Designer
As a result I want to see the following grouping:
Facebook Github No answer MSDN 3DTotal Artstation Behance Developer 2 3 1 1 0 0 0 Designer 0 0 0 0 1 2 1
How can I do that? Please assist. The main problem is how to transform
Facebook, Github Developer No answer Developer Github, MSDN Developer
Facebook Developer No answer Developer Github Developer Github Developer Github Developer MSDN Developer
and after that I can create a pivot table without any problems.