Hi Aric

Thank you for reaching out to us.

If I understand correctly you would like the column B and C to be automatically populated when you select a value in column A?

Unfortunately this is not possible using the plugin's builtin features.

The closest workaround I can think of is using the Cascade filtering feature of our paid Powerful Filters addon. You would select the filtering option from the columns' settings to be a Selectbox and turn on Filters in a form option from the Sorting and filtering tab. 

Then turn on Cascade filtering from the Sorting and filtering tab and Hide until load from the Display tab. This will populate the results in the table related only to the selected criteria. You can choose which columns are included in the filters from each column's settings. But I'm afraid the filters need to be manually selected.