Visitor Survey problem with data entry.

For each observation Data variables have been imputed and listed for each observation (or respondents).

I would like to create a record (value 1) in the table parallel for each variable. I have inputted the first two rows to show the intended output.


I have over a 1,000 rows of data so this will save some time.

Attached Files

Data Input.xlsx (10.0 KB, 10 views)

You could insert:
=COUNTIF($B2:$L2,O$1)
into O2 and copy that across & down to AA10
You can hide 0 results, if you want, either via a custom number format or the worksheet 0 display options.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Brilliant, thanks