Pull the values from the excel table structure

[aparanjith1]

Hi,

I am using an excel sheet which is formatted in a table structure and I need to pull the values from that table. Below is the image of the table in excel.

As shown in the above image, the column value for 'PDs Non-stress horizon (yr) 85%' = 1 and 'PDs Non-stress horizon (yr) 95%' = 1. Similarly we should have the values for next four values. I tried to use transpose but that is not fetching me correct results. Can someone help me in this?

Thanks!

[abhishekyx]

Hi @AmeliaG 

I have similar query but with more complex table in my excel template and I would like to take the output from the excel template?

please check the attached example. I would really appreciate your help here.

Regard,

ab