Extracting data from specific cells to make a new column

[AnaLG]

Hi,

I have a table in Excel and some important data such as the company name and the date are on top of the actual table. I would like to be able to extract that data and create two new columns in my table. 

The first image is what I have at the minute and the second one is what I want to achieve. Would you know how to achieve this?

Thanks in advance.

Ana

[Raj · Accepted solution]

@AnaLG 
find the workflow attached

mark done if solved.

[AnaLG]

That's great. Thanks for the solution Raj.