Coding for a question with multiple answers in Excel

[achuts]

Hi all i have done a google survey where i have Multiple response answers .There are 400 responses and i wanted to do the analysis from the multiple responses.But before that i have to make the data in a code.

Example

Response	Which part of the travel made you feel unsafe?	Jounery to the busstop	waiting for the bus during night	Never	Travelling in bus at night
1​	Never	0	0	1	0
2​	waiting for the bus during night	0	1	0	0
3​	waiting for the bus during night	0	1	0	0
4​	Travelling in bus at night , waiting for the bus during night	0	1	0	1
5​	waiting for the bus during night	0	1	0	1
6​	Travelling in bus at night , waiting for the bus during night
7​	Travelling in bus at night , waiting for the bus during night
8​	Travelling in bus at night , waiting for the bus during night
9​	Jounery to the busstop
10​	Travelling in bus at night , waiting for the bus during night

I need the response for the format of 3-6 column kind of response.with is data in the first two column how do we generate euation to get values like this in 3rd 4th 5 th and 6 th column
It will be great if someone helps me with this
Thanks in Advance