Want to link up multiple things (Joining, Combining fields

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

DeliveryRaw data (2).xlsx

Accepted answers

iamviraj13

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

All comments

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

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

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335