Dynamic columns header find a string from a set of files and get rows after the found text

[Manjari]

Hi All, 

I have a set of files with different structure. I am using a batch macro to pull data from each file.

Each file has different set of column headers.

My goal is to I need to find a string searching all the columns in each file and find the column that has the string and rename the column to "Column found". Using that column I would like to extract the rows from the whole data set after the string is found. 

My approach: Using Transpose and Filter I found the column name which has the string then used append to have the column name in all rows through out the data set. 

My next step is to rename this column name dynamically as the string can be found in any column in a different file.

Requesting help

[IraWatt]

Hey @Manjari,

Can you give an example of an input and desired output. Your approach with Transpose definitely sounds like the way to go from what I understood. 

[Manjari]

Hi @IraWatt , 

I could not upload a file as I am in a secured network. Apologies. I have attached images. 

Input files: 

The Output: 

Output 2: 

[ddiesel · Accepted solution]

Hi @Manjari!

Will something like this work?

Let us know if this helps.

Thanks,
Deb

[Manjari]

Thank you @ddiesel  it worked like a charm. :)

[ddiesel]

@Manjari 

Great! Glad it helped!

Thanks,
Deb