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!
Solved! Go to Solution.
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