Summarize data with dynamic date header

[tiverson]

I have a Excel data sheet that I pull data from and analyze with other data sheets

The data sheet has a date used in the header of the columns that I want to use in the final summary, however it is not located on the first row (it is a formatted table that starts the data a few rows down)

(data source #1)

Data sheet 2 (GL detail)

I want to create a summarized table that uses the date headers from the first data sheet with GL detail from another data sheet

(Column F will be a calculation from the first sheet, column G will be the summed totals from the second sheet.

That way anytime I insert a new file into the workflow, the dates will appear

The biggest thing I struggle with is getting the date headers from the first sheet when it is located on the 4th row of the excel file. 

Thanks,

Todd

[binuacs · Accepted solution]

@tiverson 

[tiverson]

So the dynamic rename tool will change the header name to whatever is listed on a file that is input into the workflow?

[Akash__on]

yes, it will. use the option from the dropdown menu.

even you can change the name of the fields using the formula window in this tool itself.