Forum Discussion

depple's avatar
depple
Icon for Helper III rankHelper III
7 years ago

Get data from "header" rows as column

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
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

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's avatar
depple
Icon for Helper III rankHelper III
7 years ago

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