Create an array for filtered and non-contiguous columns

Hello everyone
I have in my file filtered data based on column G

I need to create an array of the values of these filtered data for two columns (B & G) only

In other word to store the values of these two filtered columns (visible rows only) not all the values