I'm trying to make a modelled data source looking like this:
Ref; Text/Number
90ea892d... ; Gehandicaptenzorg
13b95396... ; 8
I can't seem to get the answers to line up with the correct reference code, because there are answers with two different types (text and number). I would be fine with one column for the numbers and one column for the text-answers but I'd still need them to correspond to the right reference. I've been trying to use LOOKUP and GROUP but can't seem to get it to work. Any tips?