From above table i need to extract data of yellow highlighted columns but there are two catches in that.
first is that i need to check if “REAMER” exist in that row if exist then pick its corresponding value from yellow highlighted columns, problem is that there are some values which are in below rows of corresponding rows,so how to create a logic so that it checks “reamer” condition and then check if it is empty then check below row of that then go to next column and check for the same.
Hi @ankur_kaushik2 ,
You can
-check “REAMER” exist
-next column check it blank or not
if it’s blank get next row
regards,
LNV
yes i tried that but if in first row it is blank then i need to check second if second also blank then i need to append null value and do same for all.
This image is input?
You can share expect result?