Hi

I have say 10 cells which hold data originating from survey software (radio buttons)
Each of these cells has either a '1' in it or is blank

e.g. 1 blank blank 1 blank blank 1 blank blank blank

Is there a way to combine these results into a new cell which holds the following data

1001001000

Thanks

Bob M