Search through columns and find specific text and replace that text with header column

[adamzee]

I need help with a macro that searches through columns of a table and picks up the letter x and replaces the letter x with the header of that particular column.
Once the letter x has been replaced with the header, the structure of the data changes from a table to list the items that have changed from x to the headers downwards.

I have attached an example file.

Any help would be appreciated.

[:) Sixthsense :)]

Run this code from the output sheet

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Please Login or Register  to view this content.

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

[Kamboj]

with the help of this macro you can arrange your data excel file attached.

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

PS: Created a Sheets Output to memic the results sheet.

[apo]

Here's another...

Please Login or Register  to view this content.

[adamzee]

Thanks for everyone's help! Perfect