Hi everyone,
I have an excel file that has data that looks like this:
Services |
BC-1 |
0 |
0 |
BC-1 MI-1 |
0 |
BC-1 PC-1 MI-1 |
Assess B-1 BC-1 HR-1 MHA-1 |
CC-1 |
Assess B-1 BC-1 |
HR-4 |
BN-1 |
What I would like to do is transpose each category into a column from each cell. So what I would like is:
BC | MI | PC | AssessB | HR | BN | MHA | CC |
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 |
1 | 0 | 0 | 1 | 1 | 0 | 1 | 0 |
0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 4 | 0 | 0 | 0 |
Any help would be greatly appreciated thank you!