Store marked complete based on question

[Cio]

Hello, 

I am having trouble coming up with the solution or if its even possible. 

I have a client that runs multiple questions per location and as long as one is answered that store is marked complete. 

The store can have up to 20 questions.  The other detail is that the 1st question is the important one. So if question 1 and 2 are answered we want to Display question 1, but if question 3 and 4 are answered, we want to display the one that was answered first.  

How can I do that? 

[Cio]

Here is the data and the desired output. Hope this helps. 

Store	Question	Answer	Complete/Not Complete
1	New Release	Yes	Complete
1	Promotion	No
1	Support	No
2	New Release	Yes	Complete
2	Promotion	"Blank"
2	Support	"Blank"
2	Distribution	"Blank"
3	New Release	"Blank"	Complete
3	Promotion	"Blank"
3	Support	Yes
3	Distribution	"Blank"
3	Remodel	"Blank"
4	New Release	"Blank"	Complete
4	Promotion	"Blank"
4	Support	"Blank"
4	Distribution	Yes
4	Remodel	"Blank"
5	New Release	"Blank"	Complete
5	Promotion	"Blank"
5	Support	"Blank"
5	Distribution	"Blank"
5	Remodel	Yes
6	New Release	Yes	Complete
6	Promotion	Yes
6	Support	"Blank"
6	Distribution	"Blank"
7	New Release	"Blank"	Not Complete
7	Promotion	"Blank"
7	Support	"Blank"
7	Distribution	"Blank"
8	New Release	"Blank"	Complete
8	Promotion	Yes
8	Support	Yes
9	New Release	"Blank"	Not Complete
9	Promotion	"Blank"
9	Support	"Blank"
9	Distribution	"Blank"
10	New Release	"Blank"	Not Complete
10	Promotion	"Blank"
10	Support	"Blank"

[ryan_mayu · Accepted solution]

@Cio 

pls see the attachment below

[ryan_mayu]

could you pls paste the data here (not the screenshot)?

and what's the expected output based on the sample data you provided?