extract specific data from few columns

[Sara Kaffashi]

Hi everyone!

I have a table with column A is the utility providers (national Grid), rent, mortgage and other fees and in column B I have amounts. What I need is to extract national Grid from column A and relevant amount from column B and extract them as a new table.

Thanks

[#2]

@Sara Kaffashi 

Hi Sara,

Could you please provide small sample file to illustrate how it looks like.