Work on excel when table is inbetwwen

[manoj2500 (robo)]

how to wok on this excel i need to get the band details in the table that is there Resource requirement - Sales

please do check the sample that is added as file is.xls type and
headers are in multiple rows as wellSAMPLE.xlsx (17.8 KB)

[balupad14 (Balamurugan)]

Hi @manoj2500,

Here I have attached a solution for your situation.

Output :

Design :

Sample :
manoj2500.zip (57.8 KB)

Thank you
Balamurugan.S