Getting the Dates

[KamenRider]

Hi

Can someone help me extract or get the reporting date and the run date? and then get the car code rows to be place as headers? See also attached excel.

 

Thanks,

Kamen

[binu_acs]

@KamenRider Read the above file through input tool then screen shot the output, it is very difficult create a workflow based on the above screen shot

[KamenRider]

Hi @binu_acs 

Attaching an excel file for your reference.

[Yoshiro_Fujimori · Accepted solution]

Hi @KamenRider ,

It seems the report lacks the detailed data (only the header row).

So I added fake rows to show how it works.

Also it seems the report can have multilple pages.

As it is not clear how the new pages look like, I did not work on the case of multiple pages.

I hope it helps.

Workflow

Output

[KamenRider]

Great @Yoshiro_Fujimori .. Thank you so much for your ideas.

Kamen