Get data in column by status x

How to get like in result
Desire result like in column F(result)
If status is "x" then get header a,b,c
if c not have x then goto to next row
If status by x IMG_20210410_012325.jpg

Please explain how you get the results in column F. There is no correlation from where you have an x to what you show in column F.

In row 2 you have x in a, b, but result is a, b, b, b
In row 6 you have x in b, but result is c
In row 10 you have x in b, c, but no result.

Row 2 b2:C2 = "x"
Then F2:F3 = value in B1:C1
a,b next to status row 6 c6 = x then we get value in C1 =b
And in row 10 c10 and d10 = x
Then we get value in C1 and d1 =b and c

May be in F2:

Please Login or Register  to view this content.

if B6 contain x
Result become a,a,b,b,b,c
Should be a,b,a,b,b,c

OK. Try again:

Please Login or Register  to view this content.

Thank.you that is solved