Character variables to columns

[hwangnyc]

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! 

[Patrick]

@hwangnyc 

Looking at your Have and Want data I can't figure out the transpose logic. Can you please elaborate?