Macro to find column headers wherever we have "x" as value

[ajoshi76]

Hi

I am attaching the sample file. Columns and Rows can be "n" numbers.
The macro should pick the column A and paste it in the resultant table
And then each row based on the value "x" available it should put the column headers spaced by comma.

The columns could be infinite and rows could be infinite

Can someone help.

 

[Luke M]

Check out the macro in this file. I believe it does what you requested.