Complex Data fetching

[bilboy]

Hi friends,

I have one "Source" file that captures multiple people coming at a store say A, like wise there are many stores B, C...

And a questionnaire that contains Yes, No questions capturing their responses.


The challenge i am facing is capturing this data in another file "Final" in the attached format.

The logic has to work even if the number of people is 3 (Eg. in File) or 30.

Any Idea friends!!!!

 

[Deepak]

Check with attached zip.

 

[Luke M]

Hi bilboy,

See attached. For purposed of building the report, I moved both sheets to same workbook, but you can see the formulas I used.

 

[bilboy]

Thank u Deepak, Thank u Luke that was indeed helpful

Excuse me for the belated reply, weekend break...cheers!!!