Inserting columns with numbers relative to previous data

Hi there,

Please can someone give me some advice on the following issue:

I have a spreadsheet of questionnaire responses which range from 1-7

For example:

Respondent Q1
1 4
2 3
3 7
4 6

So each row is a new respondent and each column is their response from the scale.

What I need to do is code the responses into a different form. I need them to be represented as follows:

Respondent Answer1 Answer2 Answer3 Answer4 Answer 5 Answer 6 Answer 7
1 0 0 0 1 0 0 0
2 0 0 1 0 0 0 0

So that each number then represents the place on the scale from which it was chosen.

I tried recording a macro but I think this requires something a lot more complex.

Any advice or tips would be really really appreciated.


I have attached a sample of the file.


Thanks in advance

Lucy.

Why have you enclosed the question in Code tags

There's no code in your post, it just looked strange

This should work ok

Please Login or Register  to view this content.