cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
depple Regular Visitor
Regular Visitor

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)?

 

PBIC.JPG

 

Any suggestions would be highly appreciated.

 

/depple

2 REPLIES 2
Super User
Super User

Re: Get data from "header" rows as column

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
    image.png
  2. "Promote" 1st row to headers
    image.png

Hopefully this is what you are looking for.

 

Regards,

Tom

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
depple Regular Visitor
Regular Visitor

Re: Get data from "header" rows as column

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