how to loop until last column and copy header base on row not empty.

[Step01]

i want to loop every column to check the row(row is base on "Match",so it got 3 row then will check 3 row cells) is empty or not ,if yes will copy header and paste to another sheet.

attached is Excel example

the output will have A003 because it is not empty(filled with "X").

[kersplash]

Attach a workbook showing data before and after.

[Step01]

okay, i am preparing a workbook,thanks.

[JeteMc]

It appears that the output should include only the header ID's that have X's for all ID numbers.
That being the case try (on the data sheet):
1) In B1048576 and across: =COUNTA(B1:B20)
2) In XFD2 and down: =IF(ROW()=2,B2,IF(B2<>"",XFD1&", "&B2,XFD1))
On the output sheet:
1) In B2 and down:

Please Login or Register  to view this content.

2) In C2 and down: =IF(B2="","",INDEX(Data!XFD$2:XFD$20,COUNTA(Data!XFD$2:XFD$20)))
Let us know if you have any questions.