Get data from "header" rows as column

[depple]

Hi,

Is there a way that I could get the date in row 1 column 5 as a column in my table (starts on row 5)?

Any suggestions would be highly appreciated.

/depple

[TomMartens]

Hey,

I'm not sure if I understand your query correctly, but maybe this is what you are looking for:

1. Remove top 4 rows
   
2. "Promote" 1st row to headers
   
   
   

Hopefully this is what you are looking for.

Regards,

Tom

[depple]

Hi @TomMartens ,

Thank you for looking into my question.

It it not about table headers per se (I misused the 'header' term because the date is placed in the header of the source document). The context here is gathering data from a folder with multiple similar reports, and therefore I need this time-stamp to separate each report in my joint table.

In other words: I would like to add a column to the data table with this date.

Sorry for poor explaining...

/depple