The simplest way to think about SCAN is that it applies a custom calculation to each element in a range/array and returns every intermediate result it produces along the way. If that sounds abstract, ...
In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table in it. Now select Import. Choose the table from the list that appears and ...