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

@AnaLG 
find the workflow attached

mark done if solved.

3089.yxzp