Power Platform Community Forum Thread Details

As per title, how to:

- loop through each row in the data table from pdf file

- I want to pick up value from any row in column 3 if there is a value in that specific row in column 2

- there could be situation that in column 2 (say in row 10) there is a value, then I expect row 10 from column 3 to be picked up, however I also want the value from the next row (row 11) to be picked up (if in respective row 11 of column 2 no value is detected).

Then I want to add row 10 and 11 in the same row in excel.

So by looking at the below , I wish to pick row labelled 2 with value 22 (in Column1) and corresponding info in the next column (Column2, with info from Column2 into one cell in excel - so essentially from rows labelled 2-10) and the next one to be picked up is row labelled 11 , with Column1 value 23 and corresponding info in Column2 in one excel cell