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

2 Replies

  • 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