In the top menu of Excel select Data > Get Data > From File > From PDF. Browse your files and select the PDF with the table ...
To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.
How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...