Want to link up multiple things (Joining, Combining fields

[iamviraj13]

Hi,

I have a raw data file that has almost 80 columns. My main focus is on columns Question ID, Respondent ID, and Item ID.
Like for eg: ITEM ID "143585" has a corresponding respondent ID and RespondentID has a corresponding question ID. But If I filter on question ID = 91, then ITEM ID is NULL but it has respondent IDs. I want to link all questions ids to item id's as well

Like if I filter on question ID = 91 then it should not give me null values. 

Any help is appreciated. Thanks in advance

[AbhilashR]

Hi @iamviraj13,  referring to 'Like if I filter on question ID = 91 then it should not give me null values.' from your post, what would be the logic to link all questions ids to item id's should you do this in excel?

[pankajk]

Hi @iamviraj13  - can you share your 'expected' output file as well.

thanks,

Pankaj

[iamviraj13 · Accepted solution]

Thanks for the response @pankajk .
Already found a solution to it.