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
to
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.